Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can a query reuse data???

Re: Can a query reuse data???

From: <epokopac_at_excite.com>
Date: 1 Aug 2006 12:55:11 -0700
Message-ID: <1154462111.355488.28160@s13g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US