Re: HELP!!! SORT ORDER

From: Serge Nantel <snantel_at_virtuo-cio.com>
Date: Mon, 04 Dec 2000 20:53:24 GMT
Message-ID: <8vTW5.29468$i%4.924418_at_news20.bellglobal.com>


Thank you

Yes I did and ORDER BY and I also I Check NLS_LANGUAGE.

Another option is to use NLS_SORT in your query they are the same?????.

"Mark Meyer" <mmeyer_at_raytheon.com> a écrit dans le message news: 3A2BEBD1.7491CC9F_at_raytheon.com...
> Serge Nantel wrote:
> >
> > 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 ???
>
>
> I can easily imagine this happening if you don't give Oracle explicit
> sorting instructions with ORDER BY. Did you?
>
>
> --
> Mark Meyer mmeyer_at_raytheon.com
> Raytheon Systems Company Voice (972)575-4595 Fax (972)575-5544
Received on Mon Dec 04 2000 - 21:53:24 CET

Original text of this message