Re: keep select in transaction

Użytkownik Eitan napisał:

> 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

You need to lock entire table, forcing others to wait to the end of your transaction.
Don't know if your transaction modify data in that table, but if no consider work on copy of that table.

-- 
Noel