Oracle PL/SQL – Check the Trigger status
Check the USER_TRIGGERS
table, you can get the Trigger status easily :
-- display all triggers for users
SELECT TRIGGER_NAME,STATUS FROM USER_TRIGGERS;
-- display status for a specified trigger
SELECT TRIGGER_NAME,STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'TRIGGER_NAME';
SELECT TRIGGER_NAME,STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME IN('TRIGGER_NAME_A', 'TRIGGER_NAME_B');
Sample data.
TRIGGER_NAME | STATUS |
---|---|
TRIGGER_NAME_A | ENABLED |
TRIGGER_NAME_B | DISABLED |
TRG_BEFORE_EMP_UPDATE | ENABLED |
TRG_BEFORE_PERSON_UPDATE | ENABLED |
REPCATLOGTRIG | ENABLED |
References
About Author
Comments
Subscribe
0 Comments