Triggers and Views in OracleSunday, June 8, 2014
Triggers and Views in Oracle
Extracted Page: http://www.gcreddy.com/2014/04/triggers-and-views-in-oracle.html
1.What is the trigger?Write syntax for triggers?
A Trigger is a PL/SQL block which is executed automatically basing on an event.
Triggering events are inserted, update, delete.
Trigger timing can be before, after, instead of
Create or replace trigger <TRIGGER_NAME><TIMMING><EVENT> ON <OBJECT_NAME>
2.Different types of triggers.
Triggers are divided into two types
1. Statement level trigger
2. Row level trigger
*Statement level trigger:
These triggers are executed only once irrespective of nu
Additional text has been truncated due to copyright reasons. Things without URLs and private things don't get truncated.