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 to select first 5 records from a table? : Sql dba
What is loop in pl sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
package specification-3 procedures package body-2 procedures will is execute
What are the different types of joins in sql?
How do I run a sql query in pgadmin 4?
What does “select count(1) from tab” result?
select 10 from dual; y its showing all the rows with 10?
is mysql query is case sensitive? : Sql dba
What is java sql drivermanager?
Why we use triggers in mysql?
What is bind variable in pl sql?