在线急等:一个简单的ORACLE触发器,搞定,立马解分
两张表sm_110和sm_refuse,在插入sm_110时,如果sm_110中dest_tele_num在sm_refuse表的tele_num字段中存在,则不予插入,sql server中已搞定,求oracle的具体写法,按我下面的写法,总说我缺少右刮号。
create or replace trigger sm_insert
before insert on sm_110
for each row when (exists (select tele_num from sm_refuse where tele_num= :new.dest_tele_num))
rollback
end sm_insert