yes, because a commit releases the lock on the rollback segments and oracle can overwrite them with another process.
-------------- Original message --------------
> Listers,
>
> I have a question where I need a little clarification about fetching across
> commits. Can this happen if the table being committed to is not the same
> as the tables(s) in the cursors?
>
> For example, if I had :
> cursor c1 is select empname form emp where
> dept = 100;
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 24 2004 - 12:55:57 CST
