Answer / mani

2 types
1. instead of trigger
2.After trigger

Answer / krish

triggers of 4 types
1.row & statement triggers
2.before & after triggers
3.instead of triggers
4.trigger on system event & user event

Answer / banu

INSTEAD OF triggers
AFTER triggers
CLR triggers

Answer / vijay

12 types of trigger

SATEMENT LEVEL TRIGGER
1.before insert
2.before update
3.before delete
4.after insert
5.after update
6.after delete

ROW LEVEL TRIGGER
7.before insert
8.before update
9.before delete
10.after insert
11.after update
12.after delete

Answer / ismail

Trigger are 3 types.

1. DML trigger
2. Instead-of trigger
3. System trigger

Answer / shobh raj

there are mainly five types of triggers
1 DDL trigger
2 DML trigger
3 instead of trigger
4 system event
5 user event

Answer / manoj kumar jena

Triggers are broadly 5types in datadase.
1.Row level trigger
2.Statement level Trigger
3.Before trigger
4.After Trigger
5.Instead Trigger

Answer / pranee

four types of triggers generally
row level triggers
statement level triggers
after triggers
before triggers

Answer / nitin

There is
1)DML trigger: with before/after,for each row/for statement,and for 3 types of DML operation.
2)Instead of trigger.
3)Database level trigger: Triggers on DDL statement.
4)System level trigger.

Answer / chakri

row and statement trigger
before and ofter trigger
instead off trigger
system event and user event trigger

What is pl sql in dbms?

0 Answers  

What are the different schemas objects that can be created using pl/sql?

0 Answers  

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

Does sql full backup truncate logs?

0 Answers  

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

0 Answers  

Where is all the data on the internet stored?

0 Answers  

Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,

can i give user defined exception in a package

2 Answers  

What is a sql select statement?

0 Answers  

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

What is an intersect?

0 Answers  

What is flag in sql?

0 Answers