日期:2025-07-17 00:21:36 人气:1

    A+
热门评论

oracle报错PLS-00103: 出现符号 "="在需要下列之一时

你报错的这一行不是这样写的。 create or replace trigger test1_deleteafter deleteon test1for each row declare num1 integer;begin select count(1) into num1 from CHANGELOG where id=:old.id and table_name=:old.table_name; if num1>0 the if :old.ope_type='insert' then delete from CHANGELOG where id=:old.id and table_name=:old.table_name; else update CHANGELOG set ope_type='delete' where id=:old.id and table_name=:old.table_name; end if; else insert into changelog values(:old.id,'test1','0','delete','',sysdate,'','',''); end if;end;/

阅读全文