What are nested triggers ?
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 latest version of sql?
What are pl/sql cursor exceptions?
How do I install microsoft sql?
Which constraints we can use while creating database in sql?
what is a unique key ? : Sql dba
Is mariadb a nosql database?
What is delimiter in pl sql?
what are the difference between clustered and a non-clustered index? : Sql dba
What is sequence in sql?
Name the different types of indexes in sql and define them.
What is delete command in sql?
What are all the different types of indexes?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is the use of procedures?
What is the difference between cross join and natural join?