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

Does truncate release storage space?

558


How do you delete data from a table?

540


How does index help in query performance?

565


How do you write a subquery?

521


what is the command used to fetch first 5 characters of the string? : Sql dba

1132






Enlist the characteristics of pl/sql?

1239


What is raw datatype in sql?

554


How do I view tables in mysql?

541


How do I view an execution plan in sql?

527


What is cursor status?

762


Is natural join and inner join same?

492


How can we make an if statement within a select statement?

541


Could you please provide oca (oracle 10g) dumps for my certification ?

4510


How show all rows in sql?

611


what are the non-standard sql commands supported by 'mysql'? : Sql dba

571