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 to Execute a Package in PL/SQL.?

0 Answers   MCN Solutions,

---

Explain spool.

0 Answers  

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

---

How to avoid using cursors?

0 Answers  

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

0 Answers  

---

What are the different type of joins in sql?

0 Answers  

---

What is the difference between delete, truncate and drop command?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

Explain the difference between sql and mysql.

0 Answers  

---

what are the differences between char and nchar? : Sql dba

0 Answers  

---