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

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

how do you login to mysql using unix shell? : Sql dba

0 Answers  

Is hadoop a nosql?

0 Answers  

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

How do you copy a table in sql?

0 Answers  

Is it possible for a table to have more than one foreign key?

0 Answers  

How to avoid duplicate records in a query?

0 Answers  

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

What can you do with pl sql?

0 Answers