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

Which join condition can be specified using on clause?

0 Answers  

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  

---

What is the difference between a query and a report?

0 Answers  

---

In a distributed database system, can we execute two queries simultaneously?

0 Answers  

---

What are the advantages of VIEW?

5 Answers  

---

What is time based sql injection?

0 Answers  

---

Why indexing is needed?

0 Answers  

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

Can we use delete in merge statement?

0 Answers  

---