SHARE
TWEET

Untitled

a guest Dec 11th, 2019 87 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table masini
  2. (
  3.  idm number(3) primary key,
  4.  nr_locuri number(2) not null,
  5.  nr_inmatriculare varchar2(20) not null
  6. );
  7.  
  8. create table curse
  9. (
  10.  idc number(3) primary key,
  11.  idm number(3) not null references masini(idm),
  12.  destinatie varchar2(20) not null,
  13.  data_plecarii DATE not null,
  14.  ora_plecarii varchar2(5) not null,
  15.  data_intoarcerii DATE not null
  16. );
  17.  
  18. insert into masini values(1, 18, 'SV-09-ABC');
  19. insert into masini values(2, 12, 'SV-02-FGH');
  20. insert into masini values(3, 8, 'SV-03-IJK');
  21. insert into masini values(4, 18, 'B-100-ION');
  22. insert into masini values(5, 20, 'B-102-LIC');
  23.  
  24. insert into curse values(11 1 BUCUREŞTI 03.03.2013 10 04.03.2013)
  25. insert into curse values(22 2 IAŞI 03.02.2013 10 03.02.2013)
  26. insert into curse values(33 3 CLUJ 01.04.2013 11 03.04.2013)
  27. insert into curse values(44 1 IAŞI 01.05.2013 15 01.05.2013)
  28. insert into curse values(55 4 BUCUREŞTI 01.05.2013 6 02.05.2013)
  29. insert into curse values(66 5 TIMIŞOARA 15.04.2013 8 17.04.2013)
  30. insert into curse values(77 1 CLUJ 10.04.2013 10 11.04.2013)
  31. insert into curse values(88 5 CLUJ 20.03.2013 22 22.03.2013)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top