例子Create Or Replace Trigger Trig_Caseupdate_AM
Before Update On Tameter
For Each Row
/******************************************************************************
PURPOSE: REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2003-11-14 Fred Zhang 1. Created this trigger.
******************************************************************************/
Begin
If :Old.DBBH<>:New.DBBH Then
Update Tuser Set DBBH=:New.DBBH Where DBBH=:Old.DBBH;
Update Tameter_Rt Set DBBH=:New.DBBH Where DBBH=:Old.DBBH;
Update Tameter_Rt_Archive Set DBBH=:New.DBBH Where DBBH=:Old.DBBH;
Update Tline Set CBBH=:New.DBBH Where CBBH=:Old.DBBH;
Update Tline Set LLBH1=:New.DBBH Where LLBH1=:Old.DBBH;
Update Tline Set LLBH2=:New.DBBH Where LLBH2=:Old.DBBH;
End If;
Exception
When Others Then
-- Consider logging the error and then re-raise
Raise;
End Trig_Caseupdate_AM;
Before Update On Tameter
For Each Row
/******************************************************************************
PURPOSE: REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2003-11-14 Fred Zhang 1. Created this trigger.
******************************************************************************/
Begin
If :Old.DBBH<>:New.DBBH Then
Update Tuser Set DBBH=:New.DBBH Where DBBH=:Old.DBBH;
Update Tameter_Rt Set DBBH=:New.DBBH Where DBBH=:Old.DBBH;
Update Tameter_Rt_Archive Set DBBH=:New.DBBH Where DBBH=:Old.DBBH;
Update Tline Set CBBH=:New.DBBH Where CBBH=:Old.DBBH;
Update Tline Set LLBH1=:New.DBBH Where LLBH1=:Old.DBBH;
Update Tline Set LLBH2=:New.DBBH Where LLBH2=:Old.DBBH;
End If;
Exception
When Others Then
-- Consider logging the error and then re-raise
Raise;
End Trig_Caseupdate_AM;
解决方案 »
- ORACLE服务未启动时,无法通过sqlplus启动服务
- hibernate 语句写法
- 请问有谁做过oracle9I,数据迁移(急)
- 重新 安装oracle 遇到的问题
- 10g,网上下有个三个文件一个win32_db,一个companion,还有client,三个文件的各自作用是????
- sql语句的问题?
- 为什么PROC 编译出来的程序那么大 ?有8M 阿 ?有办法缩小字节吗 ?(源程序不大)
- 用select语句检索一个表中的前100条记录,这个select语句该怎么写?
- IP地址问题?
- 急求:数据库性能问题的定位与优化的操作指导书
- 如何把xml中的数据写到oracle数据库中
- 关于外连接的菜问题,救命!!!
创建一个行级触发器
将你更新的:new.id放入包中的变量v_1中
然后再创建一个语句级触发器用v_1更新子表的id
将:new.id付给一个变量,然后用它来更新子表
after update on t_father
for each row
begin
update t_child a set a.id=:new.id where a.id=:old.id;
end;--这样就可以了.