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;