Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE edituri
- (
- cod number(5) primary key,
- nume varchar2(20) not null,
- adresa varchar2(50) not null,
- telefon varchar2(15)
- )
- CREATE TABLE carti
- (
- cod number(5) not null references edituri(cod),
- ide number(5) primary key,
- titlu varchar2(30) not null,
- autor varchar2(20) not null,
- pret number(3) not null
- )
- insert into edituri valeus(1 'NEMIRA 1 Mai, 40, Bucureşti' 0744123567)
- insert into edituri valeus(2 'NICULESCU Calea Unirii 23,Bucureşti' 0744123566)
- insert into edituri valeus(3 'ALL Calea Unirii 67,Bucureşti' 0744123565)
- insert into edituri valeus(4 'ERC PRESS Florilor 1, Bucureşti' 0744123564)
- insert into edituri valeus(5 'PETRION Pandurilor 67, Bucureşti' 0744123563)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement