我写的触发器:
create or replace trigger TRI_SYSHISTORY
after insert on case_info
for each row
declare
v_num integer;
begin
select count(id) into v_num from case_history where id=(select id from (select id from case_info order by id desc) where rownum = 1);
if v_num=0 then
insert into case_history
select * from (select * from case_info order by id desc) where rownum = 1;
end if;
end TRI_SYSHISTORY;
说明:case_info为表A,case_history为表B。请帮忙看看,谢谢
create or replace trigger TRI_SYSHISTORY
after insert on case_info
for each row
declare
v_num integer;
begin
select count(id) into v_num from case_history where id=(select id from (select id from case_info order by id desc) where rownum = 1);
if v_num=0 then
insert into case_history
select * from (select * from case_info order by id desc) where rownum = 1;
end if;
end TRI_SYSHISTORY;
说明:case_info为表A,case_history为表B。请帮忙看看,谢谢
解决方案 »
- 在oracle中如何调用包中声明的自定义函数
- oracle 视图怎么建主键或者增加个序列都行!!!
- oracle存储过程创建表并复制数据?求助高手
- PL/SQL中在package里定义的常量与在package body中的常量有什么区别?
- alter database open 报ora-00354 00353 00312错误,请帮给个解决方法,谢谢
- 请教WAS ND6.1+oracle 10g系统变慢测试方案
- weblogic81+oracle817的问题
- 在线等待 在sqlplus里面执行insert语句时 报错 急
- 在存储过程中如何保存上一次处理到的记录?
- Oracle GoldenGate 同步及复制问题
- 请问一个分组排序的问题,非常感谢大虾
- 连接oracle 10是,出错:无法解析指定的连接标识符
java.sql.SQLException: ORA-04091: 表 FCPS.CASE_INFO 发生了变化,触发器/函数不能读
------------------這個才對了
第6行。
也就是把for each row 这行删除就ok了