本人菜鸟一枚,请各位大神看看我写的触发器为什么报错:
create or replace trigger tr_tguser_insert
before insert on person
for each row
begin
SELECT p.person_id into dwcount from PERSON P where p.person_id =:new.person_id;
if dwcount like '%张%' THEN insert into tabxx(person_id,person_name)
values(:new.person_id,:new.person_name);
END IF;
end;还有就是触发器能引用视图吗,比如引用视图查询的结果判断是否插入到表里
create or replace trigger tr_tguser_insert
before insert on person
for each row
begin
SELECT p.person_id into dwcount from PERSON P where p.person_id =:new.person_id;
if dwcount like '%张%' THEN insert into tabxx(person_id,person_name)
values(:new.person_id,:new.person_name);
END IF;
end;还有就是触发器能引用视图吗,比如引用视图查询的结果判断是否插入到表里
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货