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.

Explain ddl statements in pl/sql?

0 Answers  

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

What are aggregate and scalar functions?

0 Answers  

what is sql profiler

2 Answers   Fidelity,

Explain what is dbms?

0 Answers  

What is the use of desc in sql?

0 Answers  

Which one is better subquery or joins?

0 Answers  

What is a sql profiler?

0 Answers  

What is the use of primary key?

0 Answers  

Is sql procedural language?

0 Answers  

How does sql store data?

0 Answers  

How do you optimize a stored procedure query?

0 Answers