Re: Create view with Order By

John Higgins wrote in message <37140F82.7DC87881_at_deere.com>...
>Just remember that Oracle does not guarantee that the groups will be in
>any specific order. Yes, today's Oracle sorts the rows to accomplish the
>grouping. Tomorrow, a better algorithm may be found.
>

[snip]

Even when GROUP BY actually uses sorting, GROUP BY will probably cause a different order from ORDER BY when used on VARCHAR2s which have national language characters in them.

An example: The Norwegian alphabet is ordered like this: ..., X, Y, Z, Æ, Ø, Å.

In ISO8859-1;

ascii('Æ') = 198
ascii('Ø') = 216
ascii('Å') = 197

GROUP BY will probably order by the letters' representational value: Å, Æ, Ø ORDER BY will order (if NLS is configured for Norwegian) like this: Æ, Ø, Å

Regards,

Roy Brokvam
roy.brokvam_at_conax.com Received on Wed Apr 14 1999 - 10:34:28 CDT