不要用行级触发器CREATE OR REPLACE TRIGGER TRG_APPTREEPRE_DELETE
After DELETE ON APPTREEPRE
BEGIN
Update Predata X
SET IsClassified = 0
Where not exists (select 'x'
from apptreepre
where AddressID = x.ADDRESSID);
END;
After DELETE ON APPTREEPRE
BEGIN
Update Predata X
SET IsClassified = 0
Where not exists (select 'x'
from apptreepre
where AddressID = x.ADDRESSID);
END;
解决方案 »
- 哪里可以下载‘Oracle Database 9i/10g/11g编程艺术深入数据库体系结构中文版2’
- 两个表之间循环查询引发的血案~~~~~~~~~~~~~~
- 请教,oracle中关于case表达式的问题
- 如何建立只读用户
- 急,救命呀,Oracle中怎么计算日期?
- 安装的时候Database Configuration Assistant失败!!!
- 一个小问题
- oracle 32位如何从R1升级到R2,求补丁和具体步骤。谢谢!!
- 帮忙看两个SQL语句
- oracle 触发器 的 使用
- oracle在red hat linux7。3下安装问题
- 请问ORACLE 8.17 和ORACLE 8.05可以安装在同一台WIN 2000的机器上吗?
create global temporary table tmpTable
(AddressID varchar2(10))
on commit delete rows
/CREATE OR REPLACE TRIGGER TRG_APPTREEPRE_DELETE_For_Each_Row
Before DELETE ON APPTREEPRE
For Each Row
BEGIN
insert into tmpTable (AddressID)
values (:old.AddressID);
END;
/CREATE OR REPLACE TRIGGER TRG_APPTREEPRE_DELETE
After DELETE ON APPTREEPRE
BEGIN
Update Predata X
SET IsClassified = 0
Where AddressID in (Select AddressID from tmpTable)
and not exists (select 'x'
from apptreepre
where AddressID = x.ADDRESSID);
END;
/