What does COMMIT do ?
- 4 Answers
- 9264 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 |
Is it possible to enter only time value into a column of a table in sql?
What is open database communication (odbc) in oracle?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
What are the basic element of Base configuration of an oracle Database ?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
What is the difference between truncate & delete command?
How do I escape a reserved word in oracle?
Youre getting high busy buffer waits - how can you find whats causing it?
How to connect asp pages to oracle servers?
How to create a single index for multiple columns?
What is a table index?
What is enter substitution variable in oracle?
Oracle General 
