我想用以下方式,用触发器写入日志信息,直接看代码。
create table test(id number,
name varchar2(8),
sex char(2) default '男'
);create sequence test_seq;create table test_log(
testlogid number ,
testtime date default sysdate,
teststaue varchar(20));create or replace trigger test_trigger
before insert or update or delete on scott.test
begin
case when inserting or updating or deleting then
(insert into scott.test_log(testlogid,testtime,teststaue)
values(test_log.nextval,sysdate,'成功'))
else
(insert into scott.test_log(testlogid,testtime,teststaue)
values(test_log.nextval,sysdate,'失败'))
end;
end;
create table test(id number,
name varchar2(8),
sex char(2) default '男'
);create sequence test_seq;create table test_log(
testlogid number ,
testtime date default sysdate,
teststaue varchar(20));create or replace trigger test_trigger
before insert or update or delete on scott.test
begin
case when inserting or updating or deleting then
(insert into scott.test_log(testlogid,testtime,teststaue)
values(test_log.nextval,sysdate,'成功'))
else
(insert into scott.test_log(testlogid,testtime,teststaue)
values(test_log.nextval,sysdate,'失败'))
end;
end;
解决方案 »
- 执行awrrpt.sql数据库巡检时,输入snapshots id时提示错误
- oracle根据导出.dmp文件进行恢复,出错了,帮忙看看
- 上面的SQL语句,我想让括号里的 "2021,2023,2024,2028......"内容作为动态查询的条件,
- 数据库关闭了连接不上了,大家进来看看
- 限制存储过程的某个语句的执行时间
- linux命令提示符下安装oracle装之后,如何用oracle的图形界面来创建库和表呢?
- (紧急求救)关于表分析的取消应如何处理???
- sql server的數據想轉到ORACLE去,有沒有什麼好方法啊???急用啊!!!!!
- 求一sql 语句:要把表中某字段改成唯一属性
- 简单问题:一个number(10)的字段查询时显示1.040E+09,怎样让它完全显示?
- oracle sqlloder 出错
- 从oracle中取出的字段后有空格!!
name varchar2(8),
sex char(2) default '男'
);create sequence test_seq;create table test_log(
testlogid number ,
testtime date default sysdate,
teststaue varchar(20));create or replace trigger test_trigger
before insert or update or delete on scott.test
begin
if inserting or updating or deleting then
(insert into scott.test_log(testlogid,testtime,teststaue)
values(test_seq.nextval,sysdate,'成功'))
else
(insert into scott.test_log(testlogid,testtime,teststaue)
values(test_seq.nextval,sysdate,'失败'))
end if;
end;
before insert or update or delete on scott.test
begin
if inserting or updating or deleting then
insert into scott.test_log
(testlogid, testtime, teststaue)
values
(test_seq.nextval, sysdate, '成功');
else
insert into scott.test_log
(testlogid, testtime, teststaue)
values
(test_seq.nextval, sysdate, '失败');
end if;
end;