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 is the difference between substr and instr?
How to connect to a remote server?
What is blob datatype?
Can we write insert statement in function in oracle?
Explain drop constraint oracle?
What is the difference between online and offline backups?
11. Display the client number and name and the client number and name of the person who referred that client.
How translate command is different from replace?
What is a system tablespace and when it is created?
What is the difference between I and G in Oracle?
Which is better Oracle or MS SQL? Why?
Explain table?
List out the types of joins.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How can Oracle users be audited?
