CREATE OR REPLACE TRIGGER "TG_T_USERTABLE_DEL" BEFORE
DELETE
ON "T_USERTABLE"
FOR EACH ROW
BEGIN
DELETE FROM T_ORG_USER WHERE userid=:old.userid;
DELETE FROM T_ROLE_USER WHERE userid=:old.userid;
DELETE FROM T_USER_PURVIEW WHERE userid=:old.userid;
DELETE FROM T_USER_fun_object WHERE userid=:old.userid;
END;
/
DELETE
ON "T_USERTABLE"
FOR EACH ROW
BEGIN
DELETE FROM T_ORG_USER WHERE userid=:old.userid;
DELETE FROM T_ROLE_USER WHERE userid=:old.userid;
DELETE FROM T_USER_PURVIEW WHERE userid=:old.userid;
DELETE FROM T_USER_fun_object WHERE userid=:old.userid;
END;
/
解决方案 »
- 求一update语句
- 执行导入数据库语句报错误
- Oracle求救
- Oracle怎样修改XML节点名称?全部的分都拿来了 Help~~
- 查出单个用户只显示一条的messageid, 按createdate倒排序
- 构造一个sql语句
- oracle中select语句如何增加查询行数限制?
- 请教:如何在ORACE中表达数学表达式?
- 在企業管理器里,點procedure,在選擇 view/edit details....,只能跳出個Edit Procedure得框,裡面得東東一點都
- 如何使IMP和EXP的速度更快,是不是提高share pool??
- 如何在程序中获得ORACLE的连接串?!
- 刚过完生日,放分
for delete
as
declare @userid varchar(20),
if Exists(select * from deleted)
Begin
DECLARE TempCursor CURSOR FOR select userid from deleted
Open TempCursor
FETCH NEXT FROM TempCursor INTO @userid
WHILE @@FETCH_STATUS = 0
Begin
DELETE FROM T_ORG_USER WHERE userid=@userid
DELETE FROM T_ROLE_USER WHERE userid=@userid
DELETE FROM T_USER_PURVIEW WHERE userid=@userid
DELETE FROM T_USER_fun_object WHERE userid=@userid
FETCH NEXT FROM TempCursor INTO @userid
End
Close TempCursor
DEALLOCATE TempCursor
end;