Answer / msy

12 Trigger can be created on a single table.

Answer / nishi

Before oracle 10g 12 trigger possible after oracle 10g more than 12 trigger we can use

Answer / hairreddy

we can create more no of triggers on a single table but we can apply 12 different type of triggers only on a table
before -- for this table level and row level (insert/update/delete)-----total 6
after-- for this table level and row level (insert/update/delete)-----total 6

total 12 different triggers we can write on a table

What are the datatypes available in pl/sql ?

0 Answers  

---

Why indexing is needed?

0 Answers  

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

How do I view an execution plan in sql?

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

What is primary key secondary key alternate key candidate key?

0 Answers  

---

Describe types of sql statements?

0 Answers  

---

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

---

What is Overloading of procedures ?

4 Answers   Amdocs,

---

Explain sql data types?

0 Answers  

---

Why is sql*loader direct path so fast?

0 Answers  

---