Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --haho15
- /*drop table teszttabla;
- create table teszttabla (
- elso number,
- masodik varchar2(32),
- harmadik date,
- negyedik number(4,3) --fdsf
- );
- insert into teszttabla (elso, masodik)
- values ( 134, 'szazharmincnegy' );
- insert into teszttabla
- values ( 135, 'szazhamncot', sysdate, 4.3);
- delete from teszttabla
- where elso < 135;
- */
- -- drop table oktatok cascade constraint;
- -- drop table targyak cascade constraint;
- -- drop table hallgatok cascade constraint;
- -- drop table hallgat cascade constraint;
- drop table oktatok
- drop table targyak
- drop table hallgatok
- drop table hallgat
- create table oktatok(
- okd number primary key,
- nev varchar(32),
- neptun varchar2(6)
- );
- create table targyak(
- tid number primary key,
- nev varchar2(64),
- oktato references oktatok
- );
- create table hallgatok(
- neptun varchar2(6) primary key,
- nev varchar2(32),
- beiratkozas date
- );
- create table hallgat(
- ki references hallgatok,
- mit references targyak
- );
- create table termek(
- trid number primary key,
- nev varchar2(32),
- );
- create table terembeoszt(
- mi references targyak,
- hol references termek,
- ido date
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement