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: Why does sqlplus "select" produce different order of data?

Re: Why does sqlplus "select" produce different order of data?

From: Adrian Shepherd <Adrian.Shepherd_at_BTINTERNET.COM>
Date: 1997/12/09
Message-ID: <66i1qt$77i@argon.btinternet.com>#1/1 







As always, you will never be able to guarantee the order of returned rows
unless you use ORDER BY clauses etc.. The results of your SQL*Plus probably
mean that the rows are held in different blocks and the blocks arent always
returned/re-read in the same order. Dont bother trying to work around it.
use ORDER BY etc..
Received on Tue Dec 09 1997 - 00:00:00 CST












Original text of this message













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