没执行end;下面一行输入“/”(不含引号)然后回车,才算创建。
CREATE OR REPLACE TRIGGER ww_triggerBEFORE INSERT OR UPDATE OR DELETEON lolFOR EACH ROWBEGIN INSERT INTO lol1(xh,NAME) VALUES(:old.xh,:new.nr);END ww_trigger;给你一个小例子自己对吧!
when :new.id is null