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.
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.