3,497
社区成员
发帖
与我相关
我的任务
分享特急!高分求助!帮忙解题!
请补充完整begin--end之间的内容,高分相送!谢谢!
当删除tslb表中的内容是需要检查tsxm表是否引用了该内容，如果引用则不允许操作，建立触发器
create or replace trigger trigger1 before
delete on tslb
REFERENCING NEW AS NEWL OLD AS OLDL
for each row
declare
int v_i;
begin
-------------------------------------------------------------------------
select count(1) into v_i from tsxm where TSXM_BH = OLDL.TSLB_BH;
if v_i > 1 then
end if;
---------------------------------------------------------------------------
end;
/
当删除tslb表中的内容是需要检查tsxm表是否引用了该内容，如果引用则不允许操作，建立触发器
create or replace trigger trigger1 before
delete on tslb
REFERENCING NEW AS NEWL OLD AS OLDL
for each row
declare
int v_i;
begin
-------------------------------------------------------------------------
select count(1) into v_i from tsxm where TSXM_BH = OLDL.TSLB_BH;
if v_i > 1 then
end if;
---------------------------------------------------------------------------
end;
/
...全文
请发表友善的回复…
发表回复
zhaokeke2004 2004-11-27
- 打赏
- 举报
http://community.csdn.net/Expert/topic/3593/3593092.xml?temp=.6880762
