Interested to Buy Any Domain ? << Click Here >> for more details...
What is mutating trigger?How to avoid it??
- 3 Answers
- 13714 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / megha bidve
Use autonomous transactions because is it we can use commit
inside the trigger.
Autonomous transactions allow you to leave the context of
the calling transaction, perform an independant
transaction, and return to the calling transaction without
affecting it's state. The autonomous transaction has no
link to the calling transaction, so only commited data can
be shared by both transactions.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the difference between partition and index?
What is sqlca in powerbuilder?
Can we create foreign key without primary key?
How would you reference column values before and after you have inserted and deleted triggers?
what is the difference between undefined value and null value? : Sql dba
What is package in pl sql?
Explain the purpose of %type and %rowtype data types?
What normalization means?
Can a varchar be a primary key?
what is index? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is the function that is used to transfer a pl/sql table log to a database table?
What is clause?
What are tables and fields?
How can you tell the difference between an index and a view?
