Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from USER_TABLES;
- select * from ALL_TABLES;
- create table Zamestnanec (
- OsobneCislo integer NOT NULL,
- Meno varchar2(30) NOT NULL,
- Priezvisko varchar2(30) NOT NULL,
- DatumNarodenia date NOT NULL,
- PocetDeti integer DEFAULT 0,
- Poznamka varchar2(1000),
- CONSTRAINT Zamestnanec_PK PRIMARY KEY (OsobneCislo)
- );
- insert into Zamestnanec values (5002,'Jozef','Druhy','20.3.1964', 0, 'Novy zamestnanec');
- insert into Zamestnanec (OSOBNECISLO, MENO, PRIEZVISKO, DATUMNARODENIA) values(5004,'Juraj','Mokry','18.9.2001');
- alter table ZAMESTNANEC MODIFY (DatumNarodenia date NULL); --Modifukujeme datum narodenia na NULL datum nemusi byt zadany
- alter table ZAMESTNANEC MODIFY (PocetDeti Integer DEFAULT 0);
- alter table ZAMESTNANEC DROP COLUMN Plat;
- alter table ZAMESTNANEC ADD (Plat NUMERIC DEFAULT 470 NOT NULL CHECK (Plat > 440));
- select * from zamestnanec;
- update Zamestnanec SET Plat = 480;
- update Zamestnanec SET Plat = 490 where OsobneCislo = 5004;
- -- https://pastebin.com/ZJ3gQUjd
- -- https://pastebin.com/V3byaB9B
- CREATE TABLE ODDELENIE
- (
- Cislooddelenia INTEGER NOT NULL ,
- Nazov VARCHAR2 (50) NOT NULL ,
- Skratka VARCHAR2 (5) NOT NULL ,
- Telefon VARCHAR2 (15)
- );
- ALTER TABLE ODDELENIE
- ADD CONSTRAINT "ODDELENIE PK" PRIMARY KEY ( Cislooddelenia ) ;
- Insert into ODDELENIE (CISLOODDELENIA,NAZOV,SKRATKA,TELEFON) values ('10500','Marketing','MKT',null);
- Insert into ODDELENIE (CISLOODDELENIA,NAZOV,SKRATKA,TELEFON) values ('10600','Personalistika ','PER',null);
- Insert into ODDELENIE (CISLOODDELENIA,NAZOV,SKRATKA,TELEFON) values ('10700','Výroba','VYR',null);
- Insert into ODDELENIE (CISLOODDELENIA,NAZOV,SKRATKA,TELEFON) values ('10800','Logistika','LOG',null);
- Insert into ODDELENIE (CISLOODDELENIA,NAZOV,SKRATKA,TELEFON) values ('10900','Konštrukcia','KON',null);
- Insert into ODDELENIE (CISLOODDELENIA,NAZOV,SKRATKA,TELEFON) values ('11000','Údržba','UDR',null);
- Insert into ODDELENIE (CISLOODDELENIA,NAZOV,SKRATKA,TELEFON) values ('11100','Doprava','DOP',null);
- Insert into ODDELENIE (CISLOODDELENIA,NAZOV,SKRATKA,TELEFON) values ('11200','Manažment','MAN',null);
- -- Po prepojeni tabuliek
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('530809','Matušcák','Ondrej',to_date('09.08.53','DD.MM.RR'),'0','520',null,'11200');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('401214','Hrnciar','Marián',to_date('14.12.40','DD.MM.RR'),'2','525',null,'11200');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('895202','Kovarcíková','Anna',to_date('02.02.89','DD.MM.RR'),'0','480','Na dohodu','10700');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('756230','Galová','Miriam',to_date('30.12.75','DD.MM.RR'),'0','450',null,'11000');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('605503','Lehotská','Mária',to_date('03.05.60','DD.MM.RR'),'2','490',null,'10700');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('525202','Gálisová','Eva',to_date('02.02.52','DD.MM.RR'),'1','495',null,'10900');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('601210','Grznár','Róbert',to_date('10.12.60','DD.MM.RR'),'1','505',null,'10600');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('700612','Holenciak','Pavol',to_date('12.06.70','DD.MM.RR'),'0','520',null,'11200');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('620712','Golem','František',to_date('12.07.62','DD.MM.RR'),'0','525',null,'11200');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('750603','Trajan','Adam',to_date('03.06.75','DD.MM.RR'),'3','450',null,'10900');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('800806','Belicka','Anton',to_date('06.08.80','DD.MM.RR'),'2','490',null,'10800');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('400202','Belan','Jozef',to_date('02.02.40','DD.MM.RR'),'2','450','Na dohodu','10700');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('300505','Chovanec','Ludovít',to_date('05.05.30','DD.MM.RR'),'1','490',null,'10800');
- Insert into ZAMESTNANEC (OSOBNECISLO,PRIEZVISKO,MENO,DATUMNARODENIA,POCETDETI,PLAT,POZNAMKA,CISLOODDELENIA) values ('580607','Dlhý','Milan',to_date('07.06.58','DD.MM.RR'),'0','445','Na dohodu','10500');
- alter table Zamestnanec ADD (Cislooddelenia INTEGER);
- alter table Zamestnanec ADD Constraint Oddelenie_FK FOREIGN KEY (Cislooddelenia) REFERENCES ODDELENIE (Cislooddelenia);
- select * from zamestnanec;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement