oracle ddl 觸發器

給你個修改表的觸發器吧
CREATE TABLE alter_audit_trail(
object_owner VARCHAR2(30),
object_name VARCHAR2(30),
object_type VARCHAR2(30),
alter_by_user VARCHAR2(30),
sys_event VARCHAR2(30),
alteration_time DATE);
-- 當使用者建立、修改或刪除時的模式觸發器。
CREATE OR REPLACE TRIGGER tri_alter_audit_trail
AFTER ALTER OR CREATE OR DROP ON scott.SCHEMA
BEGIN
IF sys.sysevent = 'ALTER' THEN
INSERT INTO alter_audit_trail VALUES
(sys.dictionary_obj_owner, sys.dictionary_obj_name,
sys.dictionary_obj_type, sys.login_user, 'my_alter', sysdate);
ELSIF sys.sysevent = 'CREATE' THEN
NULL;
ELSIF sys.sysevent = 'DROP' THEN
NULL;
END IF;
END; 


轉自網路