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
Define commit, rollback and savepoint?
Is sql a backend?
What are the main features of cursor?
How to fetch alternate records from a table?
Difference between table function and pipelined function?
Explain the difference between rename and alias?
give the syntax of grant and revoke commands? : Sql dba
Name the different types of indexes in sql and define them.
How many sql statements are used? Define them.
How do I restart sql?
Write a sql query to get the third highest salary of an employee from employee_table?
What is the purpose of primary key?
what are the types of join and explain each? : Sql dba
Can you inner join the same table?
What are some predefined exceptions in pl/sql?