Oraclesteps

Triggers:

What is triggers:Oracle lets you define procedures called triggers that run implicitly when an INSERT, UPDATE, or DELETE statement is issued against the associated table or, in some cases, against a view, or when database system actions occur.

Types of triggers:

1. BEFORE INSERT Trigger
2. AFTER INSERT Trigger
3. BEFORE UPDATE Trigger
4. AFTER UPDATE Trigger
5. BEFORE DELETE Trigger
6. AFTER DELETE Trigger

Syntax

The syntax to create a BEFORE INSERT Trigger in Oracle/PLSQL is:

CREATE [ OR REPLACE ] TRIGGER trigger_name
BEFORE INSERT
   ON table_name
   [ FOR EACH ROW ]

DECLARE
   -- variable declarations

BEGIN
   -- trigger code

EXCEPTION
   WHEN ...
   -- exception handling

END;