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.

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

What is a sub query? Describe its types?

0 Answers  

How to use attributes of the implicit cursor in oracle?

0 Answers  

Explain parameter file in oracle.

0 Answers  

What are the attributes of the cursor?

0 Answers  

What are dml statements in oracle?

0 Answers  

Why should I use oracle database?

0 Answers  

Can we store pictures in the database and if so, how it can be done?

0 Answers  

How are Indexes Update ?

1 Answers  

How to select all columns of all rows from a table in oracle?

0 Answers  

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,