两个表,user,userdoc,求一个触发器每当删除user表中的数据时,自动删除userdoc中相同userid的数据。这样写会出错,应该怎么写才对?谢谢
create or replace trigger userdel
before delete on user
for each row
declare
begin
delete from userdoc a where a.userid=user.userid;
end userdel;
create or replace trigger userdel
before delete on user
for each row
declare
begin
delete from userdoc a where a.userid=user.userid;
end userdel;
解决方案 »
- 求解!!!!
- 跪求一SQL.....多谢大侠
- 怎么实现将oracle数据文件存放在网络存储上
- ORACLE执行效率问题
- oracle的执行计划!
- 有谁用过Oracle10g呀,安装完之后启动Oracle服务有问题呀!
- 请教简单的函数NEXT_DAY的运用问题。。谢谢
- 请教Oracle错误:ORA-12560: TNS: 协议适配器错误
- 小弟初学oracle,在win2000下装好后,启动Enterprise Manager,连接时总是说“没有监听器”是怎么会是??
- 请回复" 请教一个查询时出现的问题,厚礼相送 (iamicexie ) ",在线等候
- 分享一段经典的oracle分页存储过程
- 请教一个问题
BEFORE DELETE
ON SCOTT.user
REFERENCING NEW AS New OLD AS Old
FOR EACH ROWBEGIN delete from userdoc where userid = :old.userid;
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END test;
/