如何创建触发器
create or replace trigger del_xs
before delete on xsb for each row
begin
insert into xsb_his(xh,xm,xb,cssj,zy,zxf,bz)
values(:old.xh,:old.xm,:old.xb,:old.cssj,:old.zy,:old.zxf,:old.bz)
end;
/
为什么老出现编译错误,我这还是从课本上抄的,哪位高手指导一下
[解决办法]
语法不对啊，去MSDN上查一下Triger的语法
[解决办法]
create trigger del_xs
on xsb
after delete
as
insert into xsb_his(xh,xm,xb,cssj,zy,zxf,bz)
values(:old.xh,:old.xm,:old.xb,:old.cssj,:old.zy,:old.zxf,:old.bz)
[解决办法]
你问的是oracle的触发器吧?
参考:
http://www.cnblogs.com/jianxh/articles/780214.html
