What does COMMIT do ?
- 4 Answers
- 9594 Views
- I also Faced
- E-Mail Answers
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 |
What is materialized view in Oracle?
What is a materialised view?
What is the difference between $oracle_base and $oracle_home?
What are the database administrators utilities available?
How would you go about verifying the network name that the local_listener is currently using?
how to we delete a row using varray
What is the difference between translate and replace in oracle?
When can Hash Cluster used ?
What is background process in Oracle?
what is the difference between data migration and production migration.
Can the query output be sorted by multiple columns in oracle?
What is flashback in Oracle?
Oracle General 
