What is mutating table?

Answer Posted / pradeep

Mutatin table means when error occurs when we create a row
level trigger on a table that attempts to access the same
table inside the trigger body

A Row-level trigger can not read from or write to the table,
on which it is fired. However a statement level trigger can
perform these actions on the table on which it is written

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is like operator in sql case sensitive?

515


what is a field in a database ? : Sql dba

548


what is a cursor? : Sql dba

561


How can we solve sql error: ora-00904: invalid identifier?

701


Explian rowid, rownum?

566






What are the different parts of a package?

636


What are the differences between in and exists clause?

575


what is user defined functions? : Sql dba

552


Which join is like an inner join?

531


What are the different tcl commands in sql?

625


Can you select everything, but 1 or 2 fields, without writer's cramp?

502


What are the two types of cursors in pl sql?

545


Is sql between inclusive?

596


What is the difference between the conventional and direct path loads? : aql loader

700


What is the meaning of disabling a trigger?

651