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

How to convert comma separated string to array in pl/sql?

601


What is normalization in a database?

614


Describe sql comments?

563


What is the syntax and use of the coalesce function?

601


What is sqlite format?

633






What is the maximum database size for sql express?

538


What is the best free sql database?

572


Does sql full backup truncate logs?

533


Write a sql query to convert all character to uppercase after hypen.

963


What is a record in pl/sql?

551


Explain some predefined exceptions.

588


What is the difference between delete, truncate and drop command?

552


What is anonymous block in sql?

640


how to get @@error and @@rowcount at the same time? : Sql dba

530


How do you select unique values in sql?

502