What does COMMIT do ?
Answers were Sorted based on User's Feedback
Answer / guest
COMMIT makes permanent the 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.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kiran
when ever a user performs commit action , the data is
permanently written the the tablespace and cannot be rolled
back
after performing the commit operation , the users in other
user sessions can view only the committed data
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sikdar
Commit is a TCL command which is used to make database
transaction parmanent.
The data is commited but it can't be rollbacked.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / annu rajput
Commit is a TCL command which is used to make database
transaction parmanent.
one the data is commited it can't be rollbacked.
Thanks
Annu Rajput
| Is This Answer Correct ? | 5 Yes | 3 No |
How to delete a column in an existing table?
How to select some rows from a table in oracle?
Why should I use oracle database?
What is Index Cluster ?
What is meant by an index?
What is concurrency in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
How to add a new column to an existing table with a default value?
What is COST-based approach to optimization ?
What are a collation and state the different types of collation sensitivity?
What exactly do quotation marks around the table name do?
What is the difference between view and materialized view in Oracle?