read uncommited
From: Frank Swarbrick <Frank.Swarbrick_at_efirstbank.com>
Date: Wed, 25 Nov 2009 13:01:46 -0700
Message-ID: <4B0D2ABA.6F0F.0085.0_at_efirstbank.com>
In DB2 you can do something like the following:
Date: Wed, 25 Nov 2009 13:01:46 -0700
Message-ID: <4B0D2ABA.6F0F.0085.0_at_efirstbank.com>
In DB2 you can do something like the following:
SELECT *
FROM MYTABLE
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?
Thanks,
Frank
-- 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