先建一個sequence：有按鈕可以直接建，也可以sql建DROP SEQUENCE _SEQUENCE;CREATE SEQUENCE _SEQUENCE START WITH 1000 MAXVALUE 99999999 MINVALUE 1 NOCYCLE NOCACHE ORDER;再建一個trigger： DROP TRIGGER _TRIGGER;CREATE OR REPLACE TRIGGER _TRIGGER BEFORE INSERT ON tablename FOR EACH ROWDECLARE nextid NUMBER;BEGIN IF :new.UserID IS NULL OR :new.UserID = 0 THEN SELECT _SEQUENCE.NEXTVAL INTO nextid FROM sys.DUAL; :new.UserID := nextid; END IF;END _TRIGGER;/
先建一個sequence：有按鈕可以直接建，也可以sql建DROP SEQUENCE _SEQUENCE;CREATE SEQUENCE _SEQUENCE START WITH 1000 MAXVALUE 99999999 MINVALUE 1 NOCYCLE NOCACHE ORDER;再建一個trigger： DROP TRIGGER _TRIGGER;CREATE OR REPLACE TRIGGER _TRIGGER BEFORE INSERT ON tablename FOR EACH ROWDECLARE nextid NUMBER;BEGIN IF :new.UserID IS NULL OR :new.UserID = 0 THEN SELECT _SEQUENCE.NEXTVAL INTO nextid FROM sys.DUAL; :new.UserID := nextid; END IF;END _TRIGGER;/