Interested to Buy Any Domain ? << Click Here >> for more details...
When the mutating error will comes? and how it will be
resolved?
- 2 Answers
- 7842 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandu
when we try to dml operation on orginal table in trigger.
then the trigger was excuted but while perfoming any action
on original table it will show mutating..
to overcome the above problem we need to create a autonamous
trasaction trigger..
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Is a secondary key the same as a foreign key?
how to add a new column to an existing table in mysql? : Sql dba
What is schema in sql?
How to read/write files from pl/sql?
how to calculate expressions with sql statements? : Sql dba
What is foreign key sql?
What are the string functions in sql?
How do rank () and dense_rank () differ?
How can you view the errors encountered in a trigger?
What does select top 1 do in sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What are the types of join in sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What do you understand by exception handling in pl/sql?
What are the different parts of a package?
