Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Tuesday, 11 April 2017

SQL Commit

This will be used to save the work.Commit is of two types.
  • Implicit
  • Explicit


This will be issued by oracle internally in two situations.
  • When any DDL operation is performed.
  • When you are exiting from SQL * PLUS.


     This will be issued by the user.

                Commit or commit work;
              * When ever you committed then the transaction was completed.
Share this article :


  1. Selamat Petang,

    Great info! I recently came across your blog and have been reading along.
    I thought I would leave my first comment. I don’t know what to say except that I have

    I noticed that after my SQL instance crashed and came back online, One of the huge databases showed as recovering 10%..20% even though it was accessible and I was able to browse tables and query. I am surprised as to why it showed as recovering when it was all up and running.

    Super likes !!! for this amazing post
    . I thinks everyone should bookmark this.

    Thanks and Regards

  2. Szia,

    What you’re saying is absolutely correctSQL Commit , but this isn’t the exact situation everywhere. Where most smart folk work on a project - why can’t you do this the Boss asks :).

    I would much appreciate to get a sample of data travelling via these steps.

    Source data to Staging server(tables) then PLSQL for data cleansing and transferring them to tbl_cleanABC or tbl_error_ABC. Checking the accuracy of data and finally PLSQL for loading to data warehouse.

    Follow my new blog if you interested in just tag along me in any social media platforms!