CREATE OR REPLACE TRIGGER tri BEFORE INSERT ON tab REFERENCING NEW AS New OLD AS Old FOR EACH ROW BEGIN SELECT sequence1.NEXTVAL INTO :NEW.id1 FROM DUAL; SELECT sequence2.NEXTVAL INTO :NEW.id2 FROM DUAL; END; 分拿来!!!
这样不行啊?出现错误 show errors时为 出现符号“end-of-file”在需要下列之一时: ; ORA-00923:为找到预期from关键字
即当向数据库里添加数据id,name,。时,vipid自增,
当向数据库里添加数据vipid,name,。时,id自增
BEFORE INSERT
ON tab REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN
SELECT sequence1.NEXTVAL INTO :NEW.id1 FROM DUAL;
SELECT sequence2.NEXTVAL INTO :NEW.id2 FROM DUAL;
END;
分拿来!!!
show errors时为
出现符号“end-of-file”在需要下列之一时:
;
ORA-00923:为找到预期from关键字