06 2011 档案
Oracle SEQUENCE
摘要: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
阅读全文
浙公网安备 33010602011771号