用SEQUENCE,你首先要有CREATE SEQUENCE或者CREATE ANY SEQUENCE权限CREATE SEQUENCE emp_sequence INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMAXVALUE -- 不设置最大值 NOCYCLE -- 一直累加,不循环 CACHE 10;
CREATE SEQUENCE emp_sequence INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMAXVALUE -- 不设置最大值 NOCYCLE -- 一直累加,不循环 CACHE 10;CREATE or Replace TRIGGER TRGname BEFORE INSERT ON 表1 REFERENCING NEW AS NEW --NEW FOR EACH ROW Begin SELECT emp_sequence.NEXTVAL INTO :NEW.id FROM DUAL; End; /
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 10;
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 10;CREATE or Replace TRIGGER TRGname
BEFORE INSERT ON 表1
REFERENCING NEW AS NEW --NEW
FOR EACH ROW
Begin
SELECT emp_sequence.NEXTVAL
INTO :NEW.id
FROM DUAL;
End;
/