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.

How are functions and procedures called in PL/SQL?

0 Answers  

---

what are the advantages of using stored procedures? : Sql dba

0 Answers  

---

What is update query?

0 Answers  

---

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

---

How many rows will return from dual table?

4 Answers   Fujitsu,

---

Is sql scripting language?

0 Answers  

---

What is the difference between database trigger and stored procedure?

0 Answers  

---

Write the order of precedence for validation of a column in a table ?

2 Answers  

---

Why use truncate instead of delete?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

How can triggers be used for the table auditing?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---