What Does Commit Do ?

1.	What Does Commit Do ?
Answer» COMMIT makes permanent changes resulting from all SQL statements in the TRANSACTION. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that START only after transaction is COMMITTED. COMMIT makes permanent changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.

Answer»

COMMIT makes permanent changes resulting from all SQL statements in the TRANSACTION. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that START only after transaction is COMMITTED.

COMMIT makes permanent changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Values That Can Be Specified For Optimizer Mode Parameter ?
What Is A Trace File And How Is It Created ?
How Many Number Of Columns A Record Group Can Have?
What Does The Term Panel Refer To With Regard To Pages?
What Is A Master Detail Relationship?
What Is A Library?
What Erase Package Procedure Does ?
What Is Mean By Program Global Area (pga) ?
What Is The Use Of Parfile Option In Exp Command ?
What Is Overloading Of Procedures ?

What Does Commit Do ?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment