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
Does truncate release storage space?
How do you delete data from a table?
How does index help in query performance?
How do you write a subquery?
what is the command used to fetch first 5 characters of the string? : Sql dba
Enlist the characteristics of pl/sql?
What is raw datatype in sql?
How do I view tables in mysql?
How do I view an execution plan in sql?
What is cursor status?
Is natural join and inner join same?
How can we make an if statement within a select statement?
Could you please provide oca (oracle 10g) dumps for my certification ?
How show all rows in sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba