Oracle Create Table With Identity

Oracle 12c öncesi;

CREATE TABLE departments (

  ID           NUMBER(10)    NOT NULL,

  DESCRIPTION  VARCHAR2(50)  NOT NULL);

ALTER TABLE departments ADD (

  CONSTRAINT dept_pk PRIMARY KEY (ID));

CREATE SEQUENCE dept_seq;

CREATE OR REPLACE TRIGGER dept_bir 

BEFORE INSERT ON departments 

FOR EACH ROW

BEGIN

  SELECT dept_seq.NEXTVAL

  INTO   :new.id

  FROM   dual;

END;

/

Oracle 12c sonrası;

CREATE TABLE t1 (c1 NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY, 
                   c2 VARCHAR2(10));