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 is record in pl sql?

0 Answers  

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

What is cursor status?

0 Answers  

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

Explain the purpose of %type and %rowtype data types?

0 Answers  

When to use inner join and left join?

0 Answers  

using comand prompt how can import table data and table space with example

2 Answers  

How do I view a sql trace file?

0 Answers  

What is a rank in sql?

0 Answers  

Where is all the data on the internet stored?

0 Answers  

What is trigger types in sql?

0 Answers  

What is union and union all keyword in sql?

0 Answers