Date: Wed, 25 Nov 2009 13:01:46 -0700
In DB2 you can do something like the following:
WITH UR; If you have, say, a batch application that is inserting a lot of rows in to a table, with no commits until the end of the job, doing the above query while the batch update job is still running will allow you to see the inserted but not yet committed rows.
Not something that you would want to do with a user application, but it's something that as a developer I have found occasionally useful (seeing what my batch job is "doing" before it's actually done).
Is there any such feature available for Oracle?
-- Frank Swarbrick Applications Architect - Mainframe Applications Development FirstBank Data Corporation - Lakewood, CO USA P: 303-235-1403Received on Wed Nov 25 2009 - 14:01:46 CST