Interested to Buy Any Domain ? << Click Here >> for more details...
What are nested triggers ?
- 6 Answers
- 33453 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
What is a recursive stored procedure?
Is sql scripting language?
What is normalization? How many normalization forms are there?
What is the difference between jpql and sql?
How do I enable sql encryption?
what is primary key? : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
How to load data with sql*loader?
what is difference between delete and truncate commands? : Sql dba
Why commit is not used in triggers?
What is delimiter sql?
How do you declare a constant?
Is left join same as join?
What is trigger and types?
What is sql prepared statement?
