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 to add new employee details in an employee_details table with the following details

653


Is foreign key mandatory?

558


Explain what is sql?

611


What is compiled query?

523


Can delete statement be rollbacked?

529






What are instead of triggers?

628


what is a trigger? : Sql dba

580


Which command is used to delete a package?

581


How do I run a sql query in pgadmin 4?

548


How do I run a script in sql developer?

498


Can we call stored procedure in function?

557


how to rename an existing table in mysql? : Sql dba

580


What is the difference between function and procedure in pl/sql?

546


What is the starting oracle error number?

569


What is procedure in pl sql?

538