Basic HTML version of Foils prepared 7 October 97

Foil 21 Transaction Control Statements

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
Transaction control statements manage the changes made by DML statements, and group DML statements into transaction. More specifically:
  • make a transaction's changes permanent (COMMIT)
  • undo the changes in a transaction, either since the transaction started or since a savepoint (ROLLBACK)
  • set a point to which you can roll back (SAVEPOINT)
  • establish properties for a transaction (SET TRANSACTION)

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998