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!


  3. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check

  4. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  5. Thanks a lot for sharing a valuable blog on OA Framework. I was browsing through the internet looking for OAF and Oracle ADF and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can find more information about OAF by attending oracle oaf online training. You can learn about interview questions by visiting OAF Interview Questions

  6. The post reminded me of my college days when we used to learn SQL. SQL might have been the first database query language for every students. As like the SQL is responsible for tracking and manipulating the data of an application or website, there exists some softwares that are focused oin tracking your business's financial expenses. One of those software is the Quickbooks. Don't worry if you stuck with the error 1603 quickbooks as the error can be resolved easily.