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 |
What are the advantages of oracle 12c?
Respected sir, Please send me technical questions related to oracle apps..
What suggestions do you have to reduce the network traffic?
How to create a table in a specific tablespace?
How to rebuild an index in oracle?
What is the use of aggregate functions in oracle?
Explain the use of owner option in exp command.
How different is ms access and oracle?
Explain joins in oracle?
How to convert characters to times in oracle?
How to set up autotrace for a user account?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?