Get the names of all Triggers currently in the database via SQL statement (Oracle SQL Developer) -
i need sql statement retrieves names of triggers setup in database. using oracle sql developer version 1.5.5, java version 1.7.
something this:
select object_name objects object_type = 'trigger'
what have pretty close:
select owner, object_name all_objects object_type = 'trigger'
or more usefully:
select owner, trigger_name, table_owner, table_name, triggering_event all_triggers
all_triggers
has other columns give more information all_objects
does, when trigger fires. can more information , other useful data dictionary view in documentation.
Comments
Post a Comment