Oracle

Database Transactions

Figo Kim 2006. 9. 2. 14:31
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.

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.

'Oracle' 카테고리의 다른 글

Advantage of COMMIT and ROLLBACK  (0) 2006.09.02
Advantage of COMMIT and ROLLBACK  (0) 2006.09.02
Database Transactions  (0) 2006.09.02
TRUNCATE statement  (0) 2006.09.02
TRUNCATE statement  (0) 2006.09.02