oracle ddl触发器案例
前提:
普通用户:cde
system用户下:
create table cde_ddl
(
event_name varchar2(10),
event_time varchar2(20)
);
create or replace trigger tri_cde_ddl after ddl on cde.schema begin insert into cde_ddl values (ora_sysevent,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')); end; / 测试: cde用户下: create table cde01 (id number); system用户下: select * from cde_ddl; ------------------------------------------- EVENT_NAME EVENT_TIME ---------- -------------------- CREATE 2020-03-05 21:50:46 ------------------------------------------- |