How to determine whether a trigger is enabled or disabled using a Oracle command?

Don't know it this helps but maybe using user_objects table

select * from USER_OBJECTS where object_type = 'TRIGGER'

this has some columns which may help

Hi,

There is an specific system table for triggers in Oracle that's USER_TRIGGERS.

U can query...
SELECT * FROM USER_TRIGGERS

to get all the information about all the triggers owned by the current user. if you know the trigger name then u can be more specific as.....
SELECT * FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'YourTriggerName'

This query will return the status of ur trigger also.

Akhil