触发器

1.创建对表的操作（增、删、改）进行记录的触发器

create or replace trigger triggerListenter
after INSERT OR UPDATE OR DELETE
on gen_studentinfo2
for each row

begin
    insert into gen_studentinfo3 (
           STUDENTCODE,
           STUDENTNUM,
           NAME,
           SHORTNAME,
           SPELL,
           IDTYPE,
           IDNUM,
           STUDENTTYPE,
           DRIVECARTYPE,
           STATUS,
           SCHOOLCODE,
           SCHOOLNAME
    )
    values (
           :old.studentcode,
           :old.studentnum,
           :old.name,
           :old.shortname,
           :old.spell,
           :old.idtype,
           :old.idnum,
           :old.studenttype,
           :old.drivecartype,
           :old.status,
           :old.schoolcode,
           :old.schoolname
     );
end triggerListenter;

 

2、创建对数据库操作的触发器

--创建用于记录事件用的表

CREATE TABLE ddl_event
(crt_date timestamp PRIMARY KEY,
 event_name VARCHAR2(20), 
 user_name VARCHAR2(10),
 obj_type VARCHAR2(20),
 obj_name VARCHAR2(20));

 

--创建用于记录事件用的触发器

CREATE OR REPLACE TRIGGER tr_ddl
AFTER DDL ON SCHEMA
BEGIN
   INSERT INTO ddl_event VALUES
   (systimestamp,ora_sysevent, ora_login_user, 
    ora_dict_obj_type, ora_dict_obj_name);
END tr_ddl;