Question

请问oracle触发器实现id自增 总是报错 请问哪里写错了谢谢

CREATE OR REPLACE TRIGGER test_id
BEFORE INSERT ON users
FOR EACH ROW
WHEN (new.id is null)
　　begin
　　select uses_sequence.nextval into :new.id from dual;
　　end;

Answer 1

给你一个参考 添加INSERTING
CREATEORREPLACETRIGGER stu_TRG
BEFOREINSERTORUPDATEOF stuID
ON Student
FOREACHROW
BEGIN
IF INSERTING THEN
SELECT stuSeq.NEXTVAL INTO :NEW.stuID FROM DUAL;
ELSE
RAISE_APPLICATION_ERROR(-20020, '不允许更新stuID值！');
ENDIF;
END;