create OR REPLACE trigger naoms_fims_notuserinfo_trigger
before update on naoms_fims_notuserinfo for each row
declare
rownums number(5);
begin
rownums = select count(*) from naoms_fims_notuserinfo n where n.update_date = to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd') and n.deptname = new.deptname and n.resouretype = new.resouretype;
if rownums>0 then
update naoms_fims_notuserinfo n set n.update_date = sysdate,n.notuse_source_count = new.notuse_source_count,n.description = new.description where n.deptname = new.deptname and n.resouretype = new.resouretype;
else
insert into naoms_fims_notuserinfo(id,notuse_source_count,description,update_date,update_employee,version,RESOURETYPE,DEPTNAME)
values(config_seq.nextval,new.notuse_source_count,new.description,sysdate,new.update_employee,0,new.RESOURETYPE,new.DEPTNAME);
end if;
end naoms_fims_notuserinfo_trigger;
before update on naoms_fims_notuserinfo for each row
declare
rownums number(5);
begin
rownums = select count(*) from naoms_fims_notuserinfo n where n.update_date = to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd') and n.deptname = new.deptname and n.resouretype = new.resouretype;
if rownums>0 then
update naoms_fims_notuserinfo n set n.update_date = sysdate,n.notuse_source_count = new.notuse_source_count,n.description = new.description where n.deptname = new.deptname and n.resouretype = new.resouretype;
else
insert into naoms_fims_notuserinfo(id,notuse_source_count,description,update_date,update_employee,version,RESOURETYPE,DEPTNAME)
values(config_seq.nextval,new.notuse_source_count,new.description,sysdate,new.update_employee,0,new.RESOURETYPE,new.DEPTNAME);
end if;
end naoms_fims_notuserinfo_trigger;
解决方案 »
- 本人安装9i和10g点set.up均无反应,求问题原题和解决办法和xp下Oracle下载链接。
- 使用 sqlldr 导数 报Field in data file exceeds maximum length
- 逻辑上的数据存放到物理上的数据存放的对应关系?
- oracle双机热备坏了,该如何修复,点上系统,兄弟们邦帮下?
- 求助,关于oracle表分区的问题。
- 求一个SQL语句
- *******如何解锁*******
- Oracle中如何忽略找不到数据的错误(错误处理还在)
- 如何整个数据库进行EXP,IMP? 当我用FULL=Y时会出现User did not exist
- 求 :最快的速度把一个表中的相关记录给删除?
- oracle 11G:File Space Bitmap Block可以修复或者重建么?
- oracle WIN7下本地的操作系统认证
另外,感觉你要实现的功能,不需要用触发器实现,
通过MERGE就可以实现
LZ可以看看MERGE语法看看符合不符合你的需要