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 |
what are sequences
What does “select count(1) from tab” result?
what is difference between procedure and function, procedure and trigger?
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
Does SQL*Plus contains pl/sql Engine?
How does postgresql compare to mysql?
What is pl sql record in oracle?
Its possible to add more than one primary key for the table
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Write a query to find the names of users that begin with "um" in sql?
What is the use of & in pl sql?
What is memory optimized?