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
Explain what does a control file contain?
What is format trigger?
Which is better Oracle or MS SQL? Why?
What is a proxy object?
What are the attributes of the cursor?
Can we save images in a database and if yes, how?
What is the usage of save points in oracle database?
How to experiment a data lock in oracle?
Explain the blob datatype?
Why cursor variables are easier to use than cursors?
What is blob data type in oracle?
What is oracle analytical function?
ABOUT IDENTITY?
How to export your connection information to a file?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
