一.建表
create table logdata(lid int , table_name char(30),update_type char(20),update_user char(20),update_date date);
二.建一个自增长序列
create sequence SEQ_D
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 20;
三.建触发器
列:studcnts
CREATE OR REPLACE TRIGGER TR_SEC_SCHOOL
BEFORE INSERT OR UPDATE OR DELETE ON STUDCNTS
BEGIN
CASE
WHEN INSERTING THEN
INSERT INTO LOGDATA VALUES(SEQ_D.NEXTVAL ,'STUDCNTS','INSERT',USER,SYSDATE);
WHEN UPDATING THEN
INSERT INTO LOGDATA VALUES(SEQ_D.NEXTVAL ,'STUDCNTS','UPDATE',USER,SYSDATE);
WHEN DELETING THEN
INSERT INTO LOGDATA VALUES(SEQ_D.NEXTVAL ,'STUDCNTS','DELETE',USER,SYSDATE);
END CASE;
END;
温馨提示:内容为网友见解,仅供参考