I got the information from my colleague itself. With that info i googled for the same. This link, will tell how to design,create and implement triggers.
If you want to know the trigger realted to a table, the following note will give youa quick update:
ALL_TRIGGERS describes owned by the current user and triggers on tables owned by the current user. If the user has the CREATE ANY TRIGGER privilege, then this view describes all triggers in the database.
DBA_TRIGGERS describes all triggers in the database.
USER_TRIGGERS describes all triggers owned by the current user. This view does not display the OWNER column.
Click here to view the reference page
Post a Comment