触发器代码如下:
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;第一次接触触发器,请大神指点。
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;第一次接触触发器,请大神指点。
解决方案 »
- oracle 11g :报错为ORA-01033 ORACLE initialization or shutdown in progress
- ORACLE 11g 怎样使用 ORACLE ODP.NET 链接网络服务器呢?
- 请问如何在package中添加或修改function或存储过程
- 写sql语句
- Hibernate的问题~请帮忙
- oralce中的包中的变量,过程/函数,是不是全局的?
- 更新全文索引出现编译错误!
- 谁有oracle JDeveloper 10G 的使用方法文档?
- 如何设置oracle支持多线程程序???
- 怎么设SID?
- oracle 11g (11.2.0.1.0) OCCI 查询自动退出的问题
- 请求帮助
是不是应该用before触发器