Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are a query and state the different types of queries and their uses?
List the types of joins used in writing subqueries?
what are archived logs?
How to use group functions in the select clause using oracle?
What are operators in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How can we force the database to use the user specified rollback segment?
What is a schema in oracle?
How do I uninstall oracle 11g?
Explain the difference between a procedure and a function?
What is system tablespace?
How to define a cusotmer as a supplier in ORACLE R12
What is a database schema in oracle?
What are the major difference between truncate and delete?
What is oracle update statement with inner join ?
