Re: HELP!!!! SORT ORDER

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Mon, 04 Dec 2000 22:26:12 GMT
Message-ID: <90h5ls$oai$1@nnrp1.deja.com>

Could you post the real select statement?

In article <qvTW5.29473$i%4.924422_at_news20.bellglobal.com>, "Serge Nantel" <snantel_at_virtuo-cio.com> wrote:
> 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?????
>
> <denevge_at_my-deja.com> a écrit dans le message news:
> 90gut3$i3q$1_at_nnrp1.deja.com...
> > Yes, such things can be very confusing.
> > The problem is that the NLS settings on the 2 environments are not
the
> > same.
> > Check NLS_LANGUAGE.
> >
> > Another option is to use NLS_SORT in your query.
> >
> > Hope this helps
> > Gert
> >
> > In article <KKRW5.28426$i%4.914102_at_news20.bellglobal.com>,
> > "Serge Nantel" <snantel_at_virtuo-cio.com> 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 ???
> > >
> > > thank you kindly
> > > Serge
> > > snantel_at_virtuo-cio.com
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 04 2000 - 16:26:12 CST