Answer / subhendu

Triggers are nested when a trigger performs an action that
initiates another trigger, which can initiate another
trigger, and so on. Triggers can be nested up to 32 levels,
and you can control whether triggers can be nested through
the nested triggers server configuration option.

Answer / sunil kumar

Nested triggers are fired due to actions of other triggers.
For example, you delete a row from TableA. A trigger on
TableA deletes row from TableB. Because you are deleting
rows from TableB,a trigger is executed on TableB to record
the deleted row is called nested trigger.........

Answer / 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.

Answer / vzxcgv

zdDSGFD

Answer / sudipta tripathy

A nested table is a table that appears as a
column in another table.But we can perform
the same operation on it as on other table.

Answer / anil_abbireddy

A table is created with in the table is called nested table

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

What are different types of statements supported by sql?

0 Answers  

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

Can a varchar be a primary key?

0 Answers  

What is the use of nvl function?

0 Answers  

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

Why do we use procedures in sql?

0 Answers  

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

Can u create a primary key with out unique index.

8 Answers  

What data types does pl/SQL have?

3 Answers  

Does sql between include endpoints?

0 Answers  

What are aggregate functions in sql?

0 Answers