Saturday 26 May 2012

Which data dictionary views have the information on the triggers that are available in the database? | PL SQL

The data dictionary views that have information on database triggers are given as follows:
    USER_OBJECTS — Contain the name and status of a trigger as well as the date and time of trigger creation
   USER_ERRORS— Contain the compilation error of a trigger
   USER_ TRIGGERS— Contain the source code of a trigger
  USER_ TRIGGER_COLS— Contain the information on columns used in triggers.