create or replace trigger autoid_tbt
before insert on T_BOOK_TYPE for each row
begin
select sqe_tbt.nextval into :new.id from dual;
end autoid_tbt;
/
before insert on T_BOOK_TYPE for each row
begin
select sqe_tbt.nextval into :new.id from dual;
end autoid_tbt;
/
before insert on T_BOOK_TYPE for each row
begin
select sqe_tbt.nextval into :new.id from dual;
end autoid_tbt;
小弟按你们说的,重新写了一启遍,最好的结果仍是:
警告: 创建的触发器带有编译错误。
看看具體 的錯誤提示是什麼?
2 before insert on T_BOOK_TYPE for each row
3 declare
4 next_id number;
5 begin
6 --select sqe_tbt.nextval into next_id from dual;
7 --:new.id:=next_id;
--先把上两句屏蔽,看看有什么问题
:new.id := sqe_tbt.nextval ;
--当然在编译时,你可以直接用数值替换sqe_tbt.nextval ;
8 end autoid_tbt;
9 /
INSERT ON "TBName" FOR EACH ROW
BEGIN
SELECT SQL_TBName_CloumN.NEXTVAL INTO :NEW.CLoumN FROM DUAL;
END; 这里是可以用的哦!