触发器代码如下:
CREATE OR REPLACE
TRIGGER WcmToItpUser
AFTER INSERT OR UPDATE OR DELETE ON wcmuser
FOR EACH ROW 
BEGIN
 case
 when inserting then
   insert into dzitp.itp_systemuser(USERID,ADDRESS,CRTIME,CRUSER,EMAIL,FAILDATE,ISDELETED,loginFails,LOGINIP,LOGINTIME,LOGINTIMES,PASSWORD,STATUS,TELPHONE,TRUENAME,USERTYPE,USERNAME) 
   values(:new.id,:new.ADDRESS,to_date(:new.CRTIME,'yyyy-mm-dd HH:mm:ss'),'wcm',:new.EMAIL,to_date(:new.CRTIME,'yyyy-mm-dd'),'1','0','127.0.0.1',to_date(:new.CRTIME,'yyyy-mm-dd HH:mm:ss'),'0','1822235B61622C4B4B6F5D28605A3334','1',:new.tel,:new.nickname,'1',:new.username);  when updating then
    update dzitp.itp_systemuser set TRUENAME=:new.nickname,ADDRESS=:new.ADDRESS where USERID=:new.id;
    when deleting then
    delete dzitp.itp_systemuser where username=:old.username;
   end case;
END;第一次接触触发器,请大神指点。