I need a sql statement that retrieves the names of all triggers currently setup in the database. I am using Oracle SQL Developer version 1.5.5, with java version 1.7.
Something like this:
select OBJECT_NAME from OBJECTS where OBJECT_TYPE = 'Trigger'
-
1you have a VERY old SQL Developer. Get the latest, I think 4.0 is already out. You can easily browse for db objects like triggerstbone– tbone2013-08-19 18:19:40 +00:00Commented Aug 19, 2013 at 18:19
-
@tbone this is what we use in oil and gas! hahaayla– ayla2013-08-19 19:08:25 +00:00Commented Aug 19, 2013 at 19:08
Add a comment
|
1 Answer
What you have is pretty close:
select owner, object_name
from all_objects
where object_type = 'TRIGGER'
Or more usefully:
select owner, trigger_name, table_owner, table_name, triggering_event
from all_triggers
all_triggers has other columns to give you more information that all_objects does, like when the trigger fires. You can get more information about this and other useful data dictionary view in the documentation.
1 Comment
ayla
Yes! that is it. Thanks sir! Looks like my OWNER and TABLE_OWNER are all the same.
