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

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

What does “select count(1) from tab” result?

10 Answers   IBM,

What is ON DELETE CASCADE?

3 Answers  

What are the types of subqueries?

0 Answers  

Why sql query is slow?

0 Answers  

Can we perform dml in function?

0 Answers  

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

What is case function?

0 Answers  

what is primary key? : Sql dba

0 Answers  

What is use of package in pl sql?

0 Answers  

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,