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.

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What are the various levels of constraints?

0 Answers  

---

What type of database is sql?

0 Answers  

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---

What is int identity in sql?

0 Answers  

---

What is sql entity?

0 Answers  

---

What does := mean in pl sql?

0 Answers  

---

What are the types of index in sql?

0 Answers  

---

What is primary key and foreign key?

0 Answers  

---

What is a clob in sql?

0 Answers  

---

What is online transaction processing (oltp)?

0 Answers  

---

what is msql? : Sql dba

0 Answers  

---