先建立序列:如 create sequence ID_SEQUENCE minvalue 1 maxvalue 1111 start with 1 increment by 1 cache 200; 然后再建触发器:如: CREATE OR REPLACE TRIGGER GenerateLineId BEFORE INSERT ON LINE FOR EACH ROW BEGIN SELECT ID_sequence.NEXTVAL INTO :new.LINEID FROM dual; END GenerateLineId;
随便找本书看看
create sequence ID_SEQUENCE
minvalue 1
maxvalue 1111
start with 1
increment by 1
cache 200;
然后再建触发器:如:
CREATE OR REPLACE TRIGGER GenerateLineId
BEFORE INSERT ON LINE
FOR EACH ROW
BEGIN
SELECT ID_sequence.NEXTVAL
INTO :new.LINEID
FROM dual;
END GenerateLineId;