同时使用触发器与函数:
create function getnum(p_id in varchar2)
return number;
as
num number;
begin
select count(1) into num from table_name where TypeID=p_id;
return num;
end;
/create trigger name_tri
before insert on table_name
for each row
begin
if :new.TypeID=getnum then
null;
else
--dothing;
end if;
end;
/但这样做也不能阻止插入语句,只能控制它不能做别的事情,还是在前端解决吧.
create function getnum(p_id in varchar2)
return number;
as
num number;
begin
select count(1) into num from table_name where TypeID=p_id;
return num;
end;
/create trigger name_tri
before insert on table_name
for each row
begin
if :new.TypeID=getnum then
null;
else
--dothing;
end if;
end;
/但这样做也不能阻止插入语句,只能控制它不能做别的事情,还是在前端解决吧.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货