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

What is delete command in sql?

762


How many types of cursors are available in pl/sql?

773


What is rtm in testing?

757


What is the difference between jpql and sql?

784


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

700






How do I create a sql script?

761


What are the different dml commands in sql?

762


Can we insert data in view?

691


Which sql most popular?

728


What is cursor in pl sql?

766


How do I filter in sql profiler?

732


what are properties of a transaction? : Sql dba

760


Is stored procedure faster than query?

732


What is substitution variable?

788


What are pl/sql packages?

762