Main Tutorials

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 Author

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

Comments

Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments