Follow us: Subscribe via RSS Feed 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 :

0 comments:

Post a Comment