Sapna Malik
What does COMMIT do?
By Sapna Malik in Databases & DBA on Jun 03 2011
  • RAHUL SHUKLA
    Jul, 2015 31

    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.

    • 2
  • Manav Pandya
    Jan, 2018 16

    commit finds all breakpoint which marked for either delete or update operation , than it will complete updation on defined breakpont

    • 1
  • Pankaj  Kumar Choudhary
    Jun, 2015 16

    Commit permanently save the transaction after commit we can rollback transaction.......

    • 1
  • Vinod Verma
    May, 2013 30

    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.

    • 1
  • Rajendra  Singh
    Sep, 2012 25

    hi how are u all of u...?

    • 1
  • Maajid Bashir
    Jul, 2012 10

    Marks the end of a successful implicit or explicit transaction.

    • 1
  • Abhinav Sood
    Jul, 2012 10

    after changes are made and user commits it,it cant be undone or in SQL rollbacked.

    • 1
  • satan singh
    Nov, 2011 7

    Commit is a TCL  command which is  used to make  database 
    transaction permanent.
    once the data is commited it can't be rollbacked.

    • 1
  • Sapna Malik
    Jun, 2011 3

    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.

    • 1
  • Jignesh Kumar
    Jun, 2018 17

    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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS