Re: HELP!!! SORT ORDER
From: Mark Meyer <mmeyer_at_raytheon.com>
Date: Mon, 04 Dec 2000 13:09:05 -0600
Message-ID: <3A2BEBD1.7491CC9F_at_raytheon.com>
Date: Mon, 04 Dec 2000 13:09:05 -0600
Message-ID: <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-5544Received on Mon Dec 04 2000 - 20:09:05 CET