Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Zakaznik
- (
- id_zakaznik NUMBER(8) NOT NULL,
- jmeno VARCHAR2(20) NOT NULL,
- prijmeni VARCHAR2(50) NOT NULL,
- telefon CHAR(15) NOT NULL,
- cislo_dokladu CHAR(15) NOT NULL,
- rc CHAR(10), -- Rodne cislo
- ic CHAR(15), -- Identifikacni Cislo (ICO)
- id_adresa NUMBER(8) NOT NULL
- )
- ;
- CREATE SEQUENCE seq_id_Zakaznik;
- INSERT INTO Zakaznik (id_zakaznik, jmeno, prijmeni, telefon, cislo_dokladu, id_adresa)
- VALUES (seq_id_Zakaznik.NEXTVAL,'Ab', 'Cd', '123456789','464321454',1);
- INSERT INTO Zakaznik (id_zakaznik, jmeno, prijmeni, telefon, cislo_dokladu, id_adresa)
- VALUES (seq_id_Zakaznik.NEXTVAL,'Ef', 'Gh', '845','454555',1);
Advertisement
Add Comment
Please, Sign In to add comment