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

标签：

本文系统来源：http://www.cnblogs.com/kexb/p/4580515.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！