CREATE OR REPLACE TRIGGER DBO.AA
AFTER DELETE
ON DBO.AA
FOR EACH ROW
begin
insert into AA_BAK values(old.aa1,old.aa2);
end;
AFTER DELETE
ON DBO.AA
FOR EACH ROW
begin
insert into AA_BAK values(old.aa1,old.aa2);
end;
解决方案 »
- oracle 升级时出现negative time问题
- 关于job_queue_processes设置重启自动恢复为0的问题
- 可以在表上加触发器来记录哪个ip哪个用户 删除这个表的记录吗?
- oracle的job执行错误!!快混不下去了
- 如何SQL语句在orcale中取空表的字段名及类型?
- 按时间分段查询人员所在机构,怎么用sql实现?
- oracle中如何实现这种功能?忽略参数
- oracle9i安装过程中的问题,请高手帮助
- 从数据中,按每个日期(天)最多取出3个数据,怎么写sql语句?
- 急-----------使用BCB连接ORACLE的问题!
- 如何实现Oracle数据库表的字段加一?
- 求一oracle书!!!!
CREATE TABLE gjpt.aa
(
a1 CHAR(20) NOT NULL,
PRIMARY KEY (a1)
);drop TABLE gjpt.aa_bak;
CREATE TABLE gjpt.aa_bak
(
a1 CHAR(20) NOT NULL,
PRIMARY KEY (a1)
);CREATE OR REPLACE TRIGGER gjpt.TRI_AA
BEFORE DELETE
ON gjpt.AA
FOR EACH ROW
begin
insert into AA_BAK (a1) values(old.a1);
end TRI_AA;楼上大侠,在帮忙看看,改了还不行
ORA-04098: 触发器 'GJPT.TRI_AA' 无效且未通过重新确认
2 AFTER DELETE
3 ON gjpt.AA
4 FOR EACH ROW
5 begin
6 insert into AA_BAK (a1) values(:old.a1);
7 end gjpt.TRI_AA;
8 /警告: 创建的触发器带有编译错误。SQL> select * from aa;A1
--------------------
3
2
1SQL> select * from aa_bak;未选定行SQL> delete from aa;
delete from aa
*
ERROR 位于第 1 行:
ORA-04098: 触发器 'GJPT.TRI_AA' 无效且未通过重新确认这是我的操作过程,大家看看吧!写了!一定给分!