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