PL/SQL - Types of Triggers in Oracle

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 32 of 166

Types of Triggers in Oracle

Total Answers and Comments: 7

Last Update: November 02, 2009 Asked by: GIRISH H.R.

Sponsored Links

Best Rated Answer

—

Submitted by: BASAVARAJ KOLUR

there are mainily 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

Above answer was rated as good by the following members:
paruchuc

May 03, 2006 10:23:58

ramiya

RE: problem 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

Is this answer useful? Yes | No

May 25, 2006 06:56:23

Kamlesh Patani

RE: Types of Triggers in Oracle

1. Before Trigger

2. After Trigger

3. Row level trigger

4. Schema Trigger

5. Instead of Trigger

6. Database Trigger

7. Statement level Trigger

Is this answer useful? Yes | No

July 10, 2006 19:44:53

umadevi

Member Since: February 2006 Contribution: 4

RE: Types of Triggers in Oracle

hai

statement level trigger

row level trigger

Is this answer useful? Yes | No

0 1

Overall Rating: -1

July 19, 2006 16:33:49

Santhosh

RE: Types of Triggers in Oracle

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

Is this answer useful? Yes | No

March 08, 2007 23:42:38

BASAVARAJ KOLUR

RE: Types of Triggers in Oracle

there are mainily 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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

September 03, 2009 06:32:02

sen_sam86

Member Since: June 2008 Contribution: 10

RE: Types of Triggers in Oracle

There is another new trigger called Compuond Trigger in 11g

Is this answer useful? Yes | No

November 01, 2009 12:58:12

lovely sethii

Member Since: June 2008 Contribution: 3

RE: Types of Triggers in Oracle

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

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank