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.

How to create a stored program unit?

1193

---

Explain oracle instance.

1154

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4542

---

How to define and use table alias names in oracle?

920

---

What are operators in oracle?

1041

---

What are the major difference between truncate and delete?

1030

---

Explain the use of Merge statement in oracle 11g

1010

---

How to rename a tablespace in oracle?

1069

---

What is ADDM Advisor in Oracle?

1155

---

Explain an index segment?

1091

---

How to start your 10g xe server?

1012

---

Please explain drop constraint oracle?

1077

---

What is the relation of a user account and a schema in oracle?

1061

---

Explain the use of rows option in exp command.

1068

---

What is a initialization parameter file in oracle?

1018

---