Interested to Buy Any Domain ? << Click Here >> for more details...
What are nested triggers ?
- 6 Answers
- 33722 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
how to enter characters as hex numbers? : Sql dba
How can we implement rollback or commit statement in a trigger?
How do I run sql?
what is a primary key? : Sql dba
How do I create a memory optimized filegroup?
Is merge a dml statement?
What is a natural join sql?
What is sql scripting?
Explain the purpose of %type and %rowtype data types?
What is foreign key and example?
What are crud methods?
Can you have more than one key in a database?
How to use distinct and count in sql query? Explain
What is fmtonly in sql?
Who is the owner of mysql database?
