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: Heber Ferraz-Leite <hferraz_at_via.at>
Date: 1997/12/05
Message-ID: <3487ecac.8353842@news.via.at>#1/1 







On 4 Dec 1997 02:40:20 GMT, dshi_at_magpage.com (David Shi) wrote:



>  echo "select * from table;" | sqlplus -s / | more




You have no order by in your select, so the order is basically random.
Data in a relational database is not ordered, so if you want it
ordered you have to specify it.




Heber

---
hferraz_at_via.at


Received on Fri Dec 05 1997 - 00:00:00 CST












Original text of this message













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