-- priklad vyuziti referenci (psql6oracle.sql) -- http://www.sallyx.org/sally/psql/psql6.php -- BEGIN EXECUTE IMMEDIATE 'DROP TABLE zamestnanci'; EXCEPTION WHEN OTHERS THEN IF SQLCODE != -942 THEN RAISE; END IF; END; / BEGIN EXECUTE IMMEDIATE 'DROP TABLE oddeleni'; EXCEPTION WHEN OTHERS THEN IF SQLCODE != -942 THEN RAISE; END IF; END; / BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE oddeleni_prim_klic_seq'; EXCEPTION WHEN OTHERS THEN IF SQLCODE != -2289 THEN RAISE; END IF; END; / CREATE TABLE oddeleni ( nazev VARCHAR2(20), telefon VARCHAR2(20), prim_klic INTEGER NOT NULL PRIMARY KEY ); CREATE SEQUENCE oddeleni_prim_klic_seq; CREATE TABLE zamestnanci ( jmeno VARCHAR2(20), prijmeni VARCHAR2(20), plat INTEGER CHECK (plat >= 0), oddeleni_id INTEGER REFERENCES oddeleni(prim_klic), rodne_cislo CHAR(10) NOT NULL PRIMARY KEY ); INSERT INTO oddeleni(nazev, telefon, prim_klic) VALUES ('Sekretariat','2 123 123 12', oddeleni_prim_klic_seq.NEXTVAL); INSERT INTO oddeleni(nazev, telefon, prim_klic) VALUES ('Pravni oddeleni','2 123 123 11', oddeleni_prim_klic_seq.NEXTVAL); INSERT INTO oddeleni(nazev, telefon, prim_klic) VALUES ('Pravni oddeleni','2 123 123 13', oddeleni_prim_klic_seq.NEXTVAL); INSERT INTO zamestnanci VALUES ('Lenka', 'Pavova',10000,1,'8001010601'); INSERT INTO zamestnanci VALUES ('Jana', 'Pavova',10000,1,'8001010602'); INSERT INTO zamestnanci VALUES ('Jana', 'Mala', 12000,1,'8001010603'); INSERT INTO zamestnanci VALUES ('Lenka', 'Pavova',15000,2,'8001010604'); INSERT INTO zamestnanci VALUES ('Tom', 'Jerry', 15000,2,'8001010605'); INSERT INTO zamestnanci VALUES ('Martin', 'Luter', 12000,2,'8001010606'); INSERT INTO zamestnanci VALUES ('Leopold','King', 13000,2,'8001010607'); INSERT INTO zamestnanci VALUES ('Tomas', 'Mann', 22000,3,'8001010608'); INSERT INTO zamestnanci VALUES ('Vasek', 'Trn', 16000,3,'8001010609'); INSERT INTO zamestnanci VALUES ('Stary', 'Osel', 9000,3,'8001010610');