Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / p.rajasekar
Autonomous transactions are started by a parent, or main,
transaction but operate
independently of the parent for transaction control. If a
commit or rollback is used
in the autonomous or main transaction, or if a failure
occurs for any reason, it does
not impact the other transaction.
Our favorite use of this feature is for logging application
events. If the need is to
log activity, regardless of the outcome, but the logging
success or failure should not
impact the application, autonomous transactions are the
perfect solution.
To create an autonomous transaction, use a pragma called
AUTONOMOUS_TRANSACTION. The pragma is placed in the
declaration section of the block.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
How many developers work on postgresql?
What is snowflake sql?
Why are aggregate functions called so?
What are data types in pl sql?
What is the best free sql database?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is a primary key called that is made up of more than one field?
Is pl sql better than sql?
What are field types?
How many types of triggers are there in pl sql?
What is difference between nchar and nvarchar?
How to rename a column in the output of sql query?
How does a self join work?
What is a rank in sql?
How to start the command-line sql*plus?
