Re: Help!!!!!!! SORT ORDER

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 5 Dec 2000 09:32:19 +0100
Message-ID: <90i995$kkb$1@s1.read.news.oleane.net>

And with an order clause it depends of your language:

SQL> alter session set nls_language='American';

Session altered.

SQL> select col from t order by col;

COL

---

AB3050
ABTYP 2 rows selected.

SQL>alter session set nls_language='German';

Session altered.

SQL>select col from t order by col;

COL

---

ABTYP
AB3050

2 rows selected.

So, check your NLS_LANG on your two platforms.

--
Have a nice day
Michel


Tom Leary <tleary1_at_uswest.net> a écrit dans le message : kbUW5.785$%L.231398_at_news.uswest.net...


> Without an order by clause, there is no guarantee of any sort order...

>

>

>

> "Serge Nantel" <snantel_at_virtuo-cio.com> wrote in message

> news:kKRW5.28423$i%4.914491_at_news20.bellglobal.com...

> > I have 2 Oracle database one running on UNIX and one running on NT4

> >

> > I run a select and the result is not the same

> >

> > On UNIX                        On NT4

> > Select bla bla bla              Select bla bla bla

> > ABTYP                            AB3050

> > AB3050                           ABTYP

> >

> > On UNIX the sort is not in the same order as the one on NT4 ???

> >

> > thank you kindly

> > Serge

> > snantel_at_virtuo-cio.com

> >

> >

> >

>

>

Received on Tue Dec 05 2000 - 02:32:19 CST