Oracle Sequence

Oracle中创建自增型栏位(1)创建Sequence对象; (2)建立一个Trigger

CREATE SEQUENCE seq_erictest
START WITH 1
INCREMENT BY 1;

CREATE OR REPLACE TRIGGER tr_seq_erictest
   BEFORE INSERT
   ON erictest
   REFERENCING NEW AS NEW OLD AS OLD
   FOR EACH ROW
BEGIN
   SELECT seq_erictest.NEXTVAL
     INTO :NEW.id
     FROM DUAL;
END;