Loading
What does COMMIT do?
10 Answers
Commit is used to save changes invoked by a transaction to the database transaction in SQL server. The commit command saves all the transactions to the database since the last COMMIT or ROLLBACK command.
Jignesh KumarPosted Jun 17, 2018, 11:55 PM
commit finds all breakpoint which marked for either delete or update operation , than it will complete updation on defined breakpont
Manav PandyaPosted Jan 16, 2018, 6:09 AM
Commit is the transactional command used to save changes invoked by a transaction to the database it saves all transactions to the database since the last Commit or RollBack Command.
RAHUL SHUKLAPosted Jul 31, 2015, 4:45 AM
Commit permanently save the transaction after commit we can rollback transaction.......
Pankaj Kumar ChoudharyPosted Jun 16, 2015, 11:15 AM
Use the COMMIT statement to end your current transaction and make permanent all changes performed in the transaction. A transaction is a sequence of SQL statements that Oracle Database treats as a single unit. This statement also erases all savepoints in the transaction and releases transaction locks.
Vinod VermaPosted May 30, 2013, 7:01 AM
hi how are u all of u...?
Rajendra SinghPosted Sep 25, 2012, 7:58 AM
Marks the end of a successful implicit or explicit transaction.
Maajid BashirPosted Jul 10, 2012, 9:44 PM
after changes are made and user commits it,it cant be undone or in SQL rollbacked.
Abhinav SoodPosted Jul 10, 2012, 6:09 AM
Commit is a TCL command which is used to make database transaction permanent. once the data is commited it can't be rollbacked.
satan singhPosted Nov 7, 2011, 5:26 AM
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.
Sapna MalikPosted Jun 3, 2011, 7:16 AM