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
How to drop a stored function?
What is private procedure oracle?
Can we connect to ORACLE db using Windows Authentication?
defination of bitmap index
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is the sid in oracle?
How can we find out the current date and time in oracle?
What are the differences between blob and clob in oracle?
What is the fastest query method to fetch data from the table?
What is a snapshot log?
How to define a specific record type?
How to resolve name conflicts between variables and columns?
How to lock and unlock a user account in oracle?
How to assign a table row to a record variable?
How to unlock the sample user account in oracle?
