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

List different type of expressions with the example.

698


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

719


What is java sql connection?

693


How do I find sql profiler?

683


what is sql profiler? : Sql dba

793






How many types of tables are there?

694


Is id a reserved word in sql?

860


What are pl sql procedures?

701


Can we join same table in sql?

738


What is auto increment feature in sql?

819


Is full outer join same as cross join?

694


What is compilation error in pl sql?

699


what are the advantages of mysql in comparison to oracle? : Sql dba

704


What are character functions?

804


Why are indexes and views important to an organization?

679