[Oracle] AUTO_INCREMENT

CREATE TABLE test (
  id NUMBER(10) NOT NULL
);

ALTER TABLE test ADD (
  CONSTRAINT dept_pk PRIMARY KEY (ID)
);

CREATE SEQUENCE test_seq START WITH 1;

CREATE OR REPLACE TRIGGER test_trg 
BEFORE INSERT ON test 
FOR EACH ROW

BEGIN
  SELECT test_seq.NEXTVAL
  INTO   :new.id
  FROM   dual;
END;
/

 

[출처] https://stackoverflow.com/questions/11296361/how-to-create-id-with-auto-increment-on-oracle