triggers

is the information about triggers stored in oracle DD?

Comments for triggers

Average Rating starstarstarstarstar

Click here to add your own comments

Feb 27, 2015
Rating
starstarstarstarstar
Oracle data dictionary
by: Anonymous

The short answer is yes. Oracle stores all the information about the database in the data dictionary. It needs this to be able to run.

In general, the data dictionary contains 3 sets of views that can show you informatoin about all the different compponents of the database. These are prefixed by "DBA_" (only accessible by users with system or sys privileges), "USER_" and "ALL_".

The DBA_* views show details about objects owned by all users.

The ALL_* views show details about objects to which the current user has access.

The USER_* views show details about objects owned by the current user.

Information about PL/SQL triggers created by the cuurent user are stored in the view USER_TRIGGERS and information about the column usage of the triggers are stored in the view USER_TRIGGERS.

The easy way to find out what data dictionary views to query to find out about a particluar type of object is to query ALL_VIEWS. For example to see what views relate to triggers you could run the following query:

SELECT view_name FROM all_views where view_name LIKE '%TRIGGER%';

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Oracle Questions.