Re: Oracle 8.1.7 sort order

"Jukka Peltonen" <jukka.peltonen_at_helsoft.fi> wrote in message news:1028632504.672626_at_ns2...
> Hello, I hope someone can explain this to me ....
> select nimikekoodi from nimike where nimikekoodi < 'N50295X350'

> 2nd clause:
> select nimikekoodi from nimike order by nimikekoodi

> '// KALV 80'
> ....
> 'N50295X350'
> ....
> 9,964VKI
>
> I think this is NOT a correct result.

The first query returns the results in an essentially unsorted order (though there may well be an indexed access path that is giving the impression of order. Your second query returns the data ordered correctly as per your query.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************