What is the maximum number of triggers,can apply to a single
table?

Answers were Sorted based on User's Feedback



What is the maximum number of triggers,can apply to a single table?..

Answer / aritra

12

Is This Answer Correct ?    17 Yes 0 No

What is the maximum number of triggers,can apply to a single table?..

Answer / gaurav

With oracle 10g and above:- unlimited
9 or below :- 12

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is meant by databases

4 Answers  


I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  


What does subquery mean in sql?

0 Answers  


I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,


What are sql ddl commands?

0 Answers  


What is the purpose of the sql select top clause?

0 Answers  


How packaged procedures and functions are called from the following?

2 Answers  


What is embedded sql what are its advantages?

0 Answers  


How do you break a loop in pl sql?

0 Answers  


What is t-sql? : Transact sql

0 Answers  


What are analytic functions in sql?

0 Answers  


i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,


Categories