摘要:
1.创建SEQUENCE(自增长列 与表无关)CREATE SEQUENCE "CEIADM_TASKS_SEQ" MINVALUE 1 MAXVALUE 99999999 INCREMENT BY 1 START WITH 1 NOCACHE 2.创建触发器,关联表CREATE OR REPLACE TRIGGER "INSERT_CEIADM_TASKS" BEFOREinsert on "CEIADM_TASKS"for each rowbeginselect "CEIADM_TASKS_SEQ".nextv 阅读全文