ramiya

• May 3rd, 2006

 

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

Kamlesh Patani

• May 25th, 2006

 

1. Before Trigger

2. After Trigger

3. Row level trigger

4. Schema Trigger

5. Instead of Trigger

6. Database Trigger

7. Statement level Trigger

umadevi

 Profile Answers by umadevi Questions by umadevi

• Jul 10th, 2006

 

hai

statement level trigger

row level trigger

Santhosh

• Jul 19th, 2006

 

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

BASAVARAJ KOLUR

• Mar 8th, 2007

 

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
?

sen_sam86

 Profile Answers by sen_sam86 

• Sep 3rd, 2009

 

There is another new trigger called Compuond Trigger in 11g

lovely sethii

 Profile Answers by lovely sethii 

• Nov 1st, 2009

 

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

S4Sandeep

 Profile Answers by S4Sandeep 

• Sep 4th, 2011

 

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

suresh kumar patra

• Oct 24th, 2011

 

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

3*2*2=12 types of trigger

prakash

• Feb 28th, 2012

 

Row level trigger

mahamadalig

 Profile Answers by mahamadalig 

• Apr 17th, 2012

 

before trigger
after trigger
row level trigger
statement level trigger

sai balaji

• Sep 8th, 2015

 

Basically we have 13 types of triggers.

1.Row level triggers (6 types)
2.Statement level triggers (6 types)
3.Instead of trigger

Row Level Triggers:
before insert on each row
before update on each row
before delete on each row
after insert on each row
after update on each row
after delete on each row

Statement Level Triggers:
before insert
before update
before delete
after insert
after update
after delete

Instead of Trigger:
mainly using for complex views.