DM8查询触发器结构

81 阅读1分钟
SELECT TRIGGER_NAME, 
TRIGGERING_TYPE AS EVENT_MANIPULATION, 
TABLE_NAME AS EVENT_OBJECT_TABLE, 
TRIGGER_BODY AS ACTION_STATEMENT 
FROM USER_TRIGGERS 
WHERE TABLE_OWNER = 'SYSDBA' AND TRIGGER_NAME = 'TEST_TRIGGER'