PL/SQL tutorial : Trigger in Oracle Database 11g Complete guide

Learn in depth about trigger in oracle database 11g, and usage of trigger in Database, different types of trigger with syntax for various events along with writing advance trigger and capturing all details regarding authentication. Explained Instead of trigger.

Trigger in Oracle,
Trigger in PL/SQL,
Oracle Trigger,
PL/SQL Trigger,
What is Trigger in pl/sql,
How to use Trigger in pl/sql,
How to write a Trigger in oracle,
How to design Trigger in pl/sql,
DDL trigger,
DML trigger,
Instead of trigger,
Compound trigger,
Logon trigger,

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

How Triggers Are Used
Triggers supplement the standard capabilities of Oracle to provide a highly customized database management system. For example, a trigger can restrict DML operations against a table to those issued during regular business hours. You can also use triggers to:

Automatically generate derived column values
Prevent invalid transactions
Enforce complex security authorizations
Enforce referential integrity across nodes in a distributed database
Enforce complex business rules
Provide transparent event logging
Provide auditing
Maintain synchronous table replicates
Gather statistics on table access
Modify table data when DML statements are issued against views
Publish information about database events, user events, and SQL statements to subscribing applications



 Write a comment


Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!