Discussion Board

Triggers You can write triggers that fire whenever one of the following operations occurs: - DML statements (INSERT, UPDATE, DELETE) on a particular table or view, issued by any user - DDL statements (CREATE or ALTER primarily) issued either by a particular schema/user or by any schema/user in the database - Database events, such as logon/logoff, errors, or startup/shutdown, also issued either by a particular schema/user or by any schema/user in the database Triggers are similar to stored procedures. A trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures. However, procedures and triggers differ in the way that they are invoked. A procedure is explicitly run by a user, application, or trigger. Triggers are implicitly fired by Oracle when a triggering event occurs, no matter which user is connected or which application is being used. Prajakta Pandit 03-1-2017 12:09 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*