Finding out if a trigger is enabled or not

[stevecal]

Here's an interesting problem; I have lost a considerable amount of hair recently with this one. I have a piece of dynamic SQL which does an ALTER TRIGGER xyz DISABLE (or ENABLE as the case may be). I can physically tell via DBMS_OUTPUT whether the triggers are firing or not, but I would like to know programatically what the situation is. The view 'all_triggers' doesn't seem to contain this information and I'm not sure where to look next. Any suggestions?

 

[Guest_imported]

Try this:
SELECT name, status from user_triggers where trigger_name = 'xyz';

 

[stevecal]

Yes, this works but also so does the same for all_triggers. I guess I must have misread the status column. Thanks.