On Mar 23, 2012, at 5:33 PM, John Fabiani wrote:
> I start a transaction.
> Begin
>
> Then I insert a lot of data - let's say two hundred rows.
>
> Now I need to read the same data (so the user can review).
>
> If the user thinks all is right then
> commit.
>
> Can I read the data I just inserted without committing?
Yes, as long as you run your SELECT within the transaction that you started.
Jonathan