Re: general question

From: Oradba Linux <oradba_linux_at_attbi.com>
Date: Sat, 28 Dec 2002 03:06:48 GMT
Message-ID: <pan.2002.12.28.03.08.27.645467@attbi.com>

On Sat, 28 Dec 2002 01:55:25 +0000, sk wrote:

> I know it is not the way the data is actually stored. If I do a "select
> *", I believe I get the correct order. I am trying to understand why/how
> the system provides the result seemingly sorted as stated below.
>
>
>
> Jim Kennedy wrote:
>

>> Pure chance.  Don't rely on it.
>> Jim
>> "sfk" <stefano1_at_att.net> wrote in message
>> news:3Q6P9.81319$hK4.6680146_at_bgtnsc05-news.ops.worldnet.att.net...
>> > Using 9i SQL on HR employees table, perform
>> >
>> > SELECT LAST_NAME FROM EMPLOYEES
>> >
>> > why do the names sort out alphabetically asc? Is there a default
>> > working?
>> >
>> >
>> >
>> >

 1* select last_name from employees

LAST_NAME

---

King
Kochhar
De Haan
Hunold
Ernst
Austin
Pataballa
Lorentz
Greenberg
Faviet
Chen

It is not sorted alphabetically . Received on Fri Dec 27 2002 - 21:06:48 CST