Re: keep select in transaction

From: Dave <solomons_dad.w.marks_and_whom_at_oracle.com>
Date: Tue, 12 Apr 2005 11:54:02 +0100
Message-ID: <d2O6e.19$5B5.68@news.oracle.com>

Eitan wrote:
> Hello,
> I want to open a transaction in oracle (9i),
> where first I declare a transaction,
> I want that any select will not be affected, as the database changes after I
> open the transaction.
>
> i.e :
>
> start transaction
> ....
> ' during this time rows were inserted to database in other transaction.
> ' I don't want that when I do the following select - I get the rows, that
> were inserted
>
> select * from table_that_was_changed_after_start_trans
> ' I don't want that the changes on the above tables will be seen on the
> result.
>
> commit transaction
>
> Thanks :)
>
>

Perform the select from a second session. This won't see uncommitted data. Received on Tue Apr 12 2005 - 05:54:02 CDT