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

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 1997/12/09
Message-ID: <SZtgymAaFJj0EwC1@ahardy.demon.co.uk>#1/1

In article <66556k$n4r$0_at_204.179.92.69>, David Shi <dshi_at_magpage.com> writes
>(please also forward your message to dshi_at_magpage.com, thanks a lot)
>
>Sorry about posting several questions at the same time, sometimes it's
>so difficult to get help from Oracle technical support.
>
>I noticed when I do a select, each time I got different order of data,
>is this a Unix buffer problem or something else?
It's because relational databases work on sets of data with no intrinsic ordering. To force an order in your output, use ORDER in your select statement.

Andy
Andy Hardy. PGP key available on request

Received on Tue Dec 09 1997 - 00:00:00 CST