oracle auto increment

CREATE SEQUENCE product_list_seq START WITH 1 INCREMENT BY 1;

CREATE OR REPLACE TRIGGER product_list_trigger

BEFORE INSERT ON PRODUCT_LIST

REFERENCING NEW AS NEW

FOR EACH ROW

BEGIN

  SELECT product_list_seq.nextval INTO :NEW.ID FROM dual;

END;

기타, 오라클 버전 확인,

SELECT * FROM v$version WHERE banner LIKE 'Oracle%';