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

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

What is sql profiling in oracle?

0 Answers  

Why do you partition data?

0 Answers  

Explain what is dbms?

0 Answers  

What are different types of triggers?

0 Answers  

What is Overloading of procedures ?

2 Answers  

how to sort records in sql?

3 Answers  

What is range partitioning?

0 Answers  

Who developed sql?

0 Answers  

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

Is stored procedure faster than query?

0 Answers  

How does sql*loader handles newline characters in a record? : aql loader

0 Answers