SHARE
TWEET

Untitled

a guest Dec 12th, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE edituri
  2. (
  3.  cod number(5) primary key,
  4.  nume varchar2(20) not null,
  5.  adresa varchar2(50) not null,
  6.  telefon varchar2(15)
  7. )
  8.  
  9.  
  10. CREATE TABLE carti
  11. (
  12.  cod number(5) not null references edituri(cod),
  13.  ide number(5) primary key,
  14.  titlu varchar2(30) not null,
  15.  autor varchar2(20) not null,
  16.  pret number(3) not null
  17. )
  18.  
  19. insert into edituri valeus(1 'NEMIRA 1 Mai, 40, Bucureşti' 0744123567)
  20. insert into edituri valeus(2 'NICULESCU Calea Unirii 23,Bucureşti' 0744123566)
  21. insert into edituri valeus(3 'ALL Calea Unirii 67,Bucureşti' 0744123565)
  22. insert into edituri valeus(4 'ERC PRESS Florilor 1, Bucureşti' 0744123564)
  23. insert into edituri valeus(5 'PETRION Pandurilor 67, Bucureşti' 0744123563)
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