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

Does user triggers have entry for trigger with compilation errors?

584


What are local and global variables and their differences?

580


How to read xml file in oracle pl sql?

498


What is sqlerrm?

536


Explain commit, rollback and savepoint.

598






What is cartesian join in sql?

550


What are the most important characteristics of pl/sql?

564


What is the difference between microsoft access and sql server?

521


What is insert command in sql?

518


how can we repair a mysql table? : Sql dba

534


Why having clause is used in sql?

530


Why do we need cursor in pl sql?

639


what is datawarehouse? : Sql dba

560


how many values can the set function of mysql take? : Sql dba

523


What is a sql statement?

521