Re: fetch across commit
- From: ryan_gaffuri@xxxxxxxxxxx
- To: zimsbait@xxxxxxxxx, Oracle List <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Nov 2004 18:52:54 +0000
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;
--
//www.freelists.org/webpage/oracle-l
Other related posts:
