CREATE TRIGGER TRI_AAA
AFTER DELETE
ON bbs2
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
DELETE bbs1 WHERE :OLD.bbs_delis = 1 and bbs_delis = 1;
END;
/
AFTER DELETE
ON bbs2
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
DELETE bbs1 WHERE :OLD.bbs_delis = 1 and bbs_delis = 1;
END;
/
解决方案 »
- 如何在MyEclipse内置的ORACAL中已经创建的表内添加数据
- oracle 报错!ora-00600;internal error code,argument:[4097],[]
- 触发器的问题
- 如何在Oracle中取得,用java写的存储过程返回的数组
- 求助 急:如何在vb里读取oracle中的clob字段?
- 如何把某一个用户的所有表和数据都导出来,然后如何再导入另一个库里按这个用户?
- 100分求oracle数据库备份方案
- 这句sql语句是什么错误了。帮忙看看。谢谢
- 请问ORACLE 9i支持ADO.NET吗?!
- 高分求解:Oracle数据库如何获得系统结构?
- 关于索引的问题,请各位老大指点下???
- 请教大家,日志是怎么做的?
[( argument [ IN | OUT | IN OUT ] [NOCOPY] datatype
[, argument [ IN | OUT | IN OUT ] [NOCOPY] datatype]...
)
]
[invoker_rights_clause] { IS | AS } { pl/sql_subprogram_body | call_spec };
begin
delete from bbs2 where bbs_delis=bbs_del;
delete from bbs1 where bbs_delis=bbs_del;
end;
after delete on bbs2
referrencing old as old_bbs2
for each row
begin
delete from bbs1 where bbs1.bbs_detlis = :old_bbs2.bbs_delis;
commit;
end tri_bbs;
/