SEQUENCE

SELECT NVL( (SELECT MAX(SEQ) FROM 테이블명 WHERE PROM_SEQ=325),0)+1 FROM DUAL

출처 : 오라클클럽CREATE SEQUENCE sequence_name [START WITH n] [INCREMENT BY n] [MAXVALUE n | NOMAXVALUE] [MINVALUE n | NOMINVALUE] [CYCLE | NOCYCLE]예문) CREATE SEQUENCE seq START WITH 1 INCREMENT BY 1 MAXVALUE 100 → 초기값 1, 증가값 1, 최대값 100