Interested to Buy Any Domain ? << Click Here >> for more details...
What are nested triggers ?
- 6 Answers
- 33505 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
Does a user_objects view have an entry for a trigger?
How can get second highest salary in sql?
What is lexical units in pl sql?
What is a database event trigger?
What does count (*) mean?
Why do we use sqlite?
What is on delete restrict?
Do foreign keys improve performance?
How delete a row in sql?
What is field delimiter?
How do I use google cloud in sql?
How many sql commands are there?
what is difference between delete and truncate commands? : Sql dba
What does over partition by mean in sql?
What sql database should I use?
