Answer / saleem

It is independent transaction>It will executes with out
interfering the parent transaction.

Answer / narender sharma

Autonomous Transaction is an independant transaction that
is intiated by parent transaction.It can modify data,
commit or rollback independent of the state of parent
transaction.It must be commited or rollback before it ended.

Answer / karthik

Hi,
this is a independent transaction done irrespective f
parent transcation.
ex:
i hv a procedure for updating the rows in a table.but
wether it updates or not i need this attempt of updating
the rows to be noted in a log table so i will write that as
a autonomous transaction(of course using the pragma)and so
it will be written in log table wether or not the main
table is updated.
Note:if ur using some dml in autonomous block then u HV to
COMMIT it else this transaction wil not get commited.

Answer / sohini

Autonomous transactions let you suspend the main
transaction, do SQL operations in the procedure or function
in which it has been declared, commit or roll back those
operations, then resume the main transaction.

Answer / sudipta kumar dhal

Autonomous transaction is an independent transaction started by another transaction,the main transaction.it can modify data,commit or rollback independent of the parent transaction is called autonomous transaction.

Answer / bernard raj

It is independent transaction.It will executes with out
interfering the parent transaction.

An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction.

Describe varray?

0 Answers  

What would you use to improve performance on an insert statement that places millions of rows into that table?

1 Answers  

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

How many types of tables supported by oracle?

0 Answers  

which language is used to develop the oracle........?

4 Answers   Infosys,

How to use "if" statements on multiple conditions?

0 Answers  

What is different types of joins?

0 Answers  

does Oracle has only one table space?

1 Answers   Oracle,

What do you mean by a deadlock?

0 Answers  

Can we convert a date to char in oracle and if so, what would be the syntax?

0 Answers  

does the query needs a hint to access a materialized view?

0 Answers