Answer / ravi

trigger are of two types
1)statement trigger.
2)row trigger.

Answer / mohan

Database triggers and Application triggers

In database triggers
(Before, after)
(row level, statement level)
(insert,update,delete)

Answer / saravanan

there are two type of triggers
1.application trigger

2.Database trigger

Answer / oracle expert

Hi Guys don't give answers what u have,u have correct
answers then post it otherwise somebody suffer in interview

Answer / sarat

There are 4 types of Triggers

# Row Triggers and Statement Triggers
# BEFORE and AFTER Triggers
# INSTEAD OF Triggers
# Triggers on System Events and User Events

A row trigger is fired each time the table is affected by
the triggering statement. A statement trigger is fired once
on behalf of the triggering statement.

BEFORE triggers run the trigger action before the triggering
statement is run. AFTER triggers run the trigger action
after the triggering statement is run.

INSTEAD OF triggers provide a transparent way of modifying
views that cannot be modified directly through DML
statements (INSERT, UPDATE, and DELETE).

Answer / kumar sudeep

1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.

All the above with differences in areas of implementaion
difference as below:
1. Database.
2. Application.

And with ways of implementation differences as below:
1. BEFORE/AFTER.
2. Insert/Update/delete.
3. Statement level/Row level.

Answer / robert son das

There are total four(4) types of triggers..

they are:
before insert----row level
before delete--row level
before update--row level

before insert----statement level
before delete--statement level
before update--statement level

after insert----row level
after delete--row level
after update--row level

after insert----statement level
after delete--statement level
after update--statement level

instead of trigger--row level
instead of trigger--statement level

Answer / arpit gautam

There are two types of triggers:

1.Row Triggers and Statement Triggers

A row trigger is fired each time the table is affected by
the triggering statement. For example, if an UPDATE
statement updates multiple rows of a table, a row trigger
is fired once for each row affected by the UPDATE
statement. If a triggering statement affects no rows, a row
trigger is not run.

A statement trigger is fired once on behalf of the
triggering statement, regardless of the number of rows in
the table that the triggering statement affects, even if no
rows are affected. For example, if a DELETE statement
deletes several rows from a table, a statement-level DELETE
trigger is fired only once.


2.BEFORE and AFTER Triggers

BEFORE triggers run the trigger action before the
triggering statement is run.

AFTER triggers run the trigger action after the triggering
statement is run.

Trigger Type Combinations
a. BEFORE statement trigger

b.BEFORE row trigger

c.AFTER statement trigger

d.AFTER row trigger


3.INSTEAD OF Triggers

INSTEAD OF triggers provide a transparent way of modifying
views that cannot be modified directly through DML
statements (INSERT, UPDATE, and DELETE). These triggers are
called INSTEAD OF triggers because, unlike other types of
triggers, Oracle fires the trigger instead of executing the
triggering statement.

4.Triggers on System Events and User Events

System events

Database startup and shutdown

Data Guard role transitions

Server error message events

User events

User logon and logoff

DDL statements (CREATE, ALTER, and DROP)

DML statements (INSERT, DELETE, and UPDATE)

Answer / rohit

I hv a question..
in my textbooks, triggers types are described as
1) table trigger
2) system event trigger
3) user event trigger

is this also right??

Answer / mohit tyagi(siyana bulandshaha

Basically there are three types of triggers, but the way to
use is differ. it doesn't matter on which we are
implementing these trigger.
triggers are:-
1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.

we can implement all these trigger on both module i.e
1.Application
2.Database

these both module are associate with the type of
implementation i.e.
1. Insert/delete/update
2. Before/After
3. Statement level/Row level

except this theory there are various ways to represent the
sql trigger. but all have the same concept for
implementation. so never confuse in order to represent the
sql trigger.

What are the usage of SAVEPOINTS?

5 Answers  

What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

What is dba in sql? : SQL DBA

0 Answers  

What is sqlca in powerbuilder?

0 Answers  

What is server name sql?

0 Answers  

What are the benefits of pl sql?

0 Answers  

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

What is window clause?

1 Answers   TCS,

what the meaning of sql

8 Answers  

What is different between union and minus?

7 Answers   Accenture, TCS,

How can I change database name in sql?

0 Answers  

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,