Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE categorii;
- DROP TABLE filme;
- CREATE TABLE categorii (id NUMBER(2) CONSTRAINT pk_categorii PRIMARY KEY, nume VARCHAR2(20));
- CREATE TABLE filme (id NUMBER(2) CONSTRAINT pk_filme PRIMARY KEY, nume VARCHAR2(20), an NUMBER(4), id_categorie NUMBER(2) CONSTRAINT fk_filme_categorii REFERENCES categorii(id));
- INSERT INTO categorii (id, nume) VALUES (1,'Animatie');
- INSERT INTO categorii (id, nume) VALUES (2,'Thriller');
- INSERT INTO categorii (id, nume) VALUES (3,'Romance');
- INSERT INTO filme (id,nume,an,id_categorie) VALUES (1,'Frozen 2',2019,1);
- INSERT INTO filme (id,nume,an,id_categorie) VALUES (2,'Joker',2019,2);
- INSERT INTO filme (id,nume,an,id_categorie) VALUES (3,'End Game',2019,2);
- INSERT INTO filme (id,nume,an,id_categorie) VALUES (4,'Let it snow',2018,3);
- SELECT DISTINCT f.nume,f.an from filme f;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement