Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE RASADNIK
- DROP TABLE BILJKA
- CREATE TABLE RASADNIK (
- IDRASADNIK NUMBER PRIMARY KEY,
- NAZIV VARCHAR(20) NOT NULL,
- MESTO VARCHAR(20) NOT NULL,
- DATUM_OSNIVANJA DATE
- );
- CREATE TABLE BILJKA (
- IDBILJKA NUMBER PRIMARY KEY,
- IDRASADNIK NUMBER,
- NAZIV VARCHAR(20) NOT NULL,
- VRSTA VARCHAR(20) NOT NULL,
- KOLICINA NUMBER
- );
- INSERT INTO RASADNIK VALUES(1,'cvece_doo','novi_sad','11-05-1984');
- INSERT INTO RASADNIK VALUES(2,'RASADNIK_ns','novi_sad','10-08-1983');
- INSERT INTO RASADNIK VALUES(3,'travarica','nis',NULL);
- INSERT INTO RASADNIK VALUES(4,'voce_produkt','beograd','01-11-1990');
- INSERT INTO RASADNIK VALUES(5,'sumarija','beograd','07-12-1988');
- INSERT INTO BILJKA VALUES(1, 1, 'bor', 'zimzeleno', 33);
- INSERT INTO BILJKA VALUES(2,3, 'narcis', 'cvece', 18);
- INSERT INTO BILJKA VALUES(3,4, 'jela', 'zimzeleno', NULL);
- INSERT INTO BILJKA VALUES(4,2, 'jabuka', 'voce', 54);
- INSERT INTO BILJKA VALUES (5,1, 'filadendron', 'cvece', 11);
- SELECT * FROM BILJKA
- #Prikazati podatke o nazivu rasadnika, mestu, nazivu biljaka
- #koje se gaje u tom rasadniku i vrsti za rasadnike za koje
- #nije definisan datum osnivanja
- SELECT R.NAZIV, R.MESTO, B.NAZIV, B.VRSTA
- FROM RASADNIK R JOIN BILJKA B
- ON R.IDRASADNIK = B.IDBILJKA
- WHERE DATUM_OSNIVANJA IS NULL
- #zadatak 8
- SELECT IDRASADNIK
- FROM RASADNIK
- ORDER BY MESTO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement