Sorry, but there is no easy way that I know of. Basically, it is not possible to do a dirty read in Oracle, under any of the isolation levels.

Therefore, you would have to come up with some elaborate scheme to maybe update some temp tables, and have people read from those, but only update the real table when you are ready. I cannot even imagine the complexities that something like this would introduce. I would seriously reconsider the necessity of this particular functionality, or the necessity of switching to Oracle :), because the two don't mix.

Sorry,

- Chris

Anyone else out there have any ideas?