Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can a query reuse data???
It goes back and fetchs the data.
The result set MUST be a "true" snapshot of the data that has been committed when a query BEGINS.
A previous result set would be a "false" snapshot of the data that has been committed when this current (new) query began.
Hope this helps clear things up. Received on Tue Aug 01 2006 - 14:55:11 CDT