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 use of sqldataadapter?

0 Answers  

---

What are the popular database management systems in the it industry?

0 Answers  

---

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

---

What operating systems are supported by oracle sql developer?

0 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

What is a column in a table?

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

---

How does index help in query performance?

0 Answers  

---

Why do we need a foreign key?

0 Answers  

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---