create or replace trigger trig_for_update
before update on sale
for each row BEGIN
update sale set aaaa=sequence_sale.nextval;
commit;
END;修改成这样
before update on sale
for each row BEGIN
update sale set aaaa=sequence_sale.nextval;
commit;
END;修改成这样
解决方案 »
- 索引问题,主键包含列A,B,C,D,E,F,G,H,经常以F,G,H来检索,是否需要对F,G,H列建立一索引?
- 游标的盛名,两种声明方法有什么区别?
- Java oracle:listener does not currently know of SID given in connect descriptor
- 求一条sql语句?
- 高分请高手给这个项目估价!
- ASP.NET+Oracle的应用程序应该安装Oracle的哪个版本?企业版,标准版or个人版?
- package和package body有什么区别?
- 关于将SQL SERVER中的数据导入到ORACLE中的问题?
- 麻烦前辈们给我说说这句SQL语句里的玄机
- Oracle RAC 集群 OEM创建服务报错
- 菜鸟求助SQL语句:如何删除这个字段?
- 一个sql遇到的挠头问题!!!!!!!!急!!!!
after update on sale
for each row BEGIN
update sale set aaaa=sequence_sale.nextval;
END;这样吧
create or replace trigger your_seq_tri
before insert on your_table1 for each row
declare
next_id number;
begin
select your_seq.nextval into next_id from dual;
:new.id := next_id;
end;
after update on sale
for each row
BEGIN
update sale set aaaa=sequence_sale.nextval;
END; 8i中触发器中不可以执行commit语句