What is a mutating table

Answer Posted / saraswathi muthuraman

IF you have a trigger on table emp_test. Inside that
trigger, your are trying to update/insert in the same table
emp_test.
Then mutating table error will occur.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I copy a table in sql?

597


Why do we create views in sql?

659


what is sql? : Sql dba

647


What is anonymous block in sql?

725


What are the different type of joins in sql?

625






What packages(if any) has oracle provided for use by developers?

5153


What is sql*loader?

668


Why left join is used in sql?

629


What is a data definition language?

665


what is an extent ? : Sql dba

669


What is rank function in sql?

632


What is use of trigger?

590


what is an index? : Sql dba

621


Is crud a cuss word?

680


Is sql between inclusive?

702