Oracle 自增长id

CREATE SEQUENCE to38_import_result_seq
INCREMENT BY 1
START WITH 10000
NOMAXVALUE
NOCYCLE
NOCACHE



CREATE OR REPLACE TRIGGER to38_import_result_tri
BEFORE INSERT ON to38_import_result
FOR EACH ROW
BEGIN
SELECT to38_import_result_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END;

Oracle 自增长id

标签：