what is autonomouse transaction?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rasmita basantia
its mainly used in that schenario where u are interested to
perform independent transaction.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / singh
eg: We can take a normal bank transaction. Each transaction
has two part one debit and other credit and if any one part
fails the whole transanction fails.
| Is This Answer Correct ? | 0 Yes | 5 No |
How do I view an execution plan in sql?
What are the types of join in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Is join and inner join the same?
What are the advantages of the packages
What is Pragma EXECPTION_INIT ? Explain the usage ?
How do I edit a trigger in sql developer?
Does db2 use sql?
What are the new features in Oracle 10g. Compared to Oracle 9i?
What is pl sql record in oracle?
what is the difference between truncate and delete statement? : Transact sql
how can we know the count/number of elements of an array? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)