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.

Answer / rasmita basantia

its mainly used in that schenario where u are interested to
perform independent transaction.

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.

what is the order of pre-defined exceptions.

6 Answers   TCS,

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

What is 19 null in sql?

0 Answers  

---

How do I create a sql script?

0 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

---

Does a user_objects view have an entry for a trigger?

0 Answers  

---

How can a function retun more than one value in oracle with proper example?

0 Answers  

---

What is the use of index in sql?

0 Answers  

---

How do I view stored procedures?

0 Answers  

---

what is a database transaction? : Sql dba

0 Answers  

---

what is the different between now() and current_date()? : Sql dba

0 Answers  

---

Does truncate table reset auto increment?

0 Answers  

---