create or replace trigger tri_user_del
after delete on user
for each row
declare
TEMP_OA VARCHAR2(11)
-- local variables here
begin
SELECT count(*) into TEMP_OA FROM un_user WHERE mobile=:OLD.mobile
if TEMP_OA>0 then
insert into un_user(mobile) values(:old.mobile);
end if;
end ;
after delete on user
for each row
declare
TEMP_OA VARCHAR2(11)
-- local variables here
begin
SELECT count(*) into TEMP_OA FROM un_user WHERE mobile=:OLD.mobile
if TEMP_OA>0 then
insert into un_user(mobile) values(:old.mobile);
end if;
end ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货