Oracle

Database Transactions

Figo Kim 2006. 9. 2. 14:31

A database transaction consist of one of the following:

  • DML statements that constitute one consistent change to the data
  • One DDL statement
  • One data control language(DCL) statement

  • Begin when the first DML SQL statements is executed.
  • End with one of the following events;
    - A COMMIT or ROLLBACK statement is issued
    - A DDL or DCL statement executes (automatic commit)
    - The user exits iSQL plus
    - The system crashes.