tuxmartin

Oracle auto-increment primary key

Jan 2nd, 2012
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE Zakaznik
  2. (
  3.     id_zakaznik    NUMBER(8) NOT NULL,
  4.     jmeno          VARCHAR2(20) NOT NULL,
  5.     prijmeni       VARCHAR2(50) NOT NULL,
  6.     telefon        CHAR(15) NOT NULL,
  7.     cislo_dokladu  CHAR(15) NOT NULL,
  8.     rc             CHAR(10),    --  Rodne cislo
  9.     ic             CHAR(15),    --  Identifikacni Cislo (ICO)
  10.     id_adresa      NUMBER(8) NOT NULL
  11. )
  12. ;
  13.  
  14.  
  15. CREATE SEQUENCE seq_id_Zakaznik;
  16.  
  17. INSERT INTO Zakaznik (id_zakaznik, jmeno, prijmeni, telefon, cislo_dokladu, id_adresa)
  18. VALUES (seq_id_Zakaznik.NEXTVAL,'Ab', 'Cd', '123456789','464321454',1);
  19.  
  20. INSERT INTO Zakaznik (id_zakaznik, jmeno, prijmeni, telefon, cislo_dokladu, id_adresa)
  21. VALUES (seq_id_Zakaznik.NEXTVAL,'Ef', 'Gh', '845','454555',1);
Advertisement
Add Comment
Please, Sign In to add comment