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

Pages

Tuesday, 11 April 2017

SQL Commit


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

Implicit


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

Explicit


     This will be issued by the user.

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

2 comments:

  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

    ReplyDelete
  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!


    Gracias

    ReplyDelete