Types of Triggers in Oracle

hi i have some problem in raise_application_error where i used it . since i used non predefined exeception then why i used it thanks ramiya

1. Before Trigger

2. After Trigger

3. Row level trigger

4. Schema Trigger

5. Instead of Trigger

6. Database Trigger

7. Statement level Trigger

hai

statement level trigger

row level trigger

3 types namely DML triggers, instead-of triggers and system triggers.

There are mainly 3 types of triggers
1> dml trigger
2>instead of trigger written on only view
3>system trigger

dml trigger written on table that gets fired on dml events like
insert or delete or update operation
that trigger may fire
1>after dml event
2> before dml event these are timings for trigger firing

instead of trigger written only on view that view is not modifiable that also gets fired
when dml event occurs

system trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
database level
schema level

There is another new trigger called Compuond Trigger in 11g

Two types of trigger are there
1. Row level trigger
2. Statement level trigger

Based on timing:
1. Before
2. After
3. Instead of

Based on Event:

1. DDL (Insert, update, delete )
2. DML ( Create, alter, analyze, comment )
3. Database ( After setup, before shutdown)

Based on scope of trigger action:

1. Row level
2. Statement level

12 types of trigger.........
insert/update/delete 3
before/after 2
row level /statement level 2

3*2*2=12 types of trigger

Row level trigger

before trigger
after trigger
row level trigger
statement level trigger