Preserve log table entries using autonomous transactions in Oracle

Thursday Sep 21st 2006 by DatabaseJournal.com Staff
Share:

Developers can use autonomous transactions in Oracle to "step outside" the main transaction and do work that commits independently.

[From Builder.com]

A database transaction is a unit of work that must either succeed completely or fail completely. In Oracle, a transaction starts with the first Data Management Language (DML) statement you execute, and ends when you issue a COMMIT statement to save the transaction or a ROLLBACK statement to throw it away.

The article continues at http://builder.com.com/5100-6388_14-6116690.html?tag=sc

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved