This blog was originally published on December 01, 2016.
In business applications, there is often the requirement to “play” with data, to simulate business scenarios or to maintain multiple versions of data. Such scenarios require “long running transactions”; changes are being made to tables from within multiple database sessions, over a longer period of time even from different users. At the end, all changes of that transactions are being applied or rejected as a whole.
We have transactions in the Oracle database since its early days, but these are restricted to the very database session and therefore also to one user. But there is also database functionality for long running transacions: Oracle Workspace Manager. Our latest Application Express Tip shows what this is and how to use it within an application.