oracle sequence

CREATE SEQUENCE applog_device_sequence

START WITH 1

INCREMENT BY 1;

시퀀스 생성 후 

CREATE OR REPLACE TRIGGER applog_device_sequence_trigger

BEFORE INSERT

ON applog_device

REFERENCING NEW AS NEW

FOR EACH ROW

BEGIN

SELECT applog_device_sequence.nextval INTO :NEW.id(증가될 컬럼명) FROM dual;

END;