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

  1. Oracle – USER_SOURCE table

About the Author

author image
mkyong
Founder of Mkyong.com, love Java and open source stuff. Follow him on Twitter, or befriend him on Facebook or Google Plus. If you like my tutorials, consider make a donation to these charities.

Comments

Leave a Reply

avatar