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 has stored procedures in sql?

0 Answers  

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

Why is stored procedure faster than query?

0 Answers  

How much does sql cost?

0 Answers  

What is a primary key sql?

0 Answers  

What are different types of indexes?

0 Answers  

what are all the different types of indexes? : Sql dba

0 Answers  

What is intersect?

1 Answers  

what are different types of collation sensitivity? : Sql dba

0 Answers  

What are different types of refreshment techniques of materialised view

2 Answers  

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers