Oracle Sequence 생성

 

CREATE SEQUENCE sequence(시퀀스명) 
START WITH 1
INCREMENT BY 1;




CREATE OR REPLACE TRIGGER sequence(시퀀스명) 
BEFORE INSERT
ON TB_PTN_INFO(테이블명) 
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT sequence.nextval INTO :NEW.PTN_NO FROM dual;
END;