What are nested triggers ?
- 6 Answers
- 31001 Views
- Amazon, Appeal Soft, IBM, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth
A trigger that contains data modification logic within
itself is called a nested trigger.
Use the nested triggers option to control whether an AFTER
trigger can cascade; that is, perform an action that
initiates another trigger, which initiates another trigger,
and so on. When nested triggers is set to 0, AFTER triggers
cannot cascade. When nested triggers is set to 1 (the
default), AFTER triggers can cascade to as many as 32
levels. INSTEAD OF triggers can be nested regardless of the
setting of this option.
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
Why do we use set serveroutput on?
What are the benefits of pl/sql packages?
Why do we use joins in sql?
How do I truncate a sql log file?
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
How many sql core licenses do I need?
What are the main features of cursor?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What does where 1/2 mean in sql?
What is difference between pls_integer and integer?
What is forward declaration in pl sql?
What is string join?
What is rename command in sql?
Difference between truncate, delete and drop commands?
What happens when a trigger is associated to a view?
