SELECT * FROM all_triggers WHERE table_name = 'YOUR_TABLE_NAME';
ALL_TRIGGERS:當前用戶可訪問的所有觸發器table_name:基礎表名稱,**必須大寫** (Oracle 預設物件名大寫存儲)TRIGGER_NAME, TRIGGER_TYPE, TRIGGERING_EVENT, STATUS, TRIGGER_BODYSELECT trigger_name, trigger_type, triggering_event, status
FROM all_triggers
WHERE table_name = 'YOUR_TABLE_NAME'
AND status = 'ENABLED'
AND trigger_type LIKE '%ROW%';
USER_TRIGGERS:當前用戶擁有的觸發器DBA_TRIGGERS:全庫觸發器 (需 DBA 權限)