我想用以下方式,用触发器写入日志信息,直接看代码。
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;
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;