Transaction processing and triggers for Oracle database notes

Characteristics of the transaction (ACID)

A (atomacity) atomicity: A transaction is a whole, and the processing statement that makes up a transaction forms a logical unit and cannot execute only part of it.

C (consistency) Consistency: database is consistent before and after transaction execution (full constraints on the database)

I (Isolation) Isolation: The processing of one transaction does not affect the processing of another transaction, which is isolated from each other

D (Durability) Persistence: The effect of transaction processing can be permanently preserved

Note: Do you want a transaction? Failure is not part of the success part of the failure

End of transaction

(1) End of display: Commit or rollback executed

(2) Implicit commit: Execution of DDL or DCL statements or exit exits

(3) Implicit rollback: System abnormal shutdown, power outage

Set Save Point

Transaction processing and triggers for Oracle database notes