• A transaction can be committed either-
  • Explicitly, or
  • Implicitly
  • Explicit commit:
  • A COMMIT command terminates the current transaction, and makes all changes permanent, made during the transaction.

                ​​​​​​Syntax :- COMMIT;

               Output :-

                            Commit complete.

  • Various data manipulation operation such as insert, update, delete are not final until they are committed.
  • A commit command puts them in effect permanently.
  • Implicitly commit:
  • There are some operations which forces a COMMIT to occur automatically, even user don’t specify the COMMIT command. These operation involve execution of-
  1. QUIT command:
  • To end SQL*PLUS session disconnecting from the Oracle.
  1. EXIT command:
  • To end SQL*PLUS session disconnecting from the Oracle.
  1. Data Definition Language (DDL) commands:
  •  Commands like CREATE... ALTER..., DROP... are immediate, and makes all prior changes made during current transaction permanent.