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 is the use of non clustered index?

0 Answers  

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

Why schema is used in sql?

0 Answers  

---

What is an ndf file?

0 Answers  

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

---

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

What is a database link?

3 Answers  

---

Does a join table need a primary key?

0 Answers  

---

When are we going to use truncate and delete?

0 Answers  

---

what are different types of collation sensitivity? : Sql dba

0 Answers  

---

how would you enter characters as hex numbers? : Sql dba

0 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---