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

Answer Posted / gaurav

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

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we optimize a sql query?

577


How can the performance of a trigger be improved?

592


What is exit statement?

550


What is the difference between a subquery and a join?

531


Explain the difference in execution of triggers and stored procedures?

573






What are the advantages of sql?

560


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1156


what is the use of set statement in tsql? : Transact sql

536


Is full outer join same as cross join?

505


How is data stored in sql?

551


What does pragma mean?

511


What is the use of procedures?

546


How do I start pl sql?

492


Why sql query is slow?

583


Why we use sql profiler?

562