USING COMMIT

This will be used to save the work.

Commit is of two types.

Ø  Implicit

Ø  Explicit

a) IMPLICIT

     This will be issued by oracle internally in two situations.

Ø  When any DDL operation is performed.

Ø  When you are exiting from SQL * PLUS.

b) EXPLICIT

     This will be issued by the user.

     Syntax:

                Commit or commit work;

              * When ever you committed then the transaction was completed.