Oracle/SQL: Check If Trigger Enabled/Disabled

Question

How do you check if a specific trigger is enabled or disabled in Oracle/SQL?

The following specifies if my trigger is valid or not -- but not enabled or disabled

SELECT *
FROM   ALL_OBJECTS
WHERE  OBJECT_TYPE = 'TRIGGER' AND OBJECT_NAME = 'the_trigger_name';

My Oracle Database version: 12c - Enterprise Edition v12.1.0.2.0 - 64bit

I have checked StackOverflow and came across the following posts, but didn't find an answer specific to Oracle/SQL:

Rushikumar · Accepted Answer · 2018-03-29 13:31:25Z

25

user_triggers is the table where all triggers created, specific to the schema, are located.

So,

SELECT STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'the_trigger_name';

will fetch the status of either ENABLED or DISABLED.

Also, to fetch ALL triggers and their statuses--

SELECT TRIGGER_NAME, STATUS FROM USER_TRIGGERS;

answered Mar 29, 2018 at 13:31

Rushikumar

1,8305 gold badges22 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mggSoft · Accepted Answer · 2021-12-30 10:27:37Z

1

This query also worked for me:

SELECT trigger_name,status
FROM dba_triggers
WHERE trigger_name = upper ('TRIGGERNAME');

answered Dec 30, 2021 at 10:27

mggSoft

1,0522 gold badges24 silver badges37 bronze badges