Message-ID: <3A2BEBD1.7491CC9F@raytheon.com> From: Mark Meyer X-Mailer: Mozilla 4.51 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle Subject: Re: HELP!!! SORT ORDER References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 21 Date: Mon, 04 Dec 2000 13:09:05 -0600 NNTP-Posting-Host: 147.25.194.19 X-Complaints-To: news@ext.ray.com X-Trace: dfw-service2.ext.raytheon.com 975956891 147.25.194.19 (Mon, 04 Dec 2000 13:08:11 CST) NNTP-Posting-Date: Mon, 04 Dec 2000 13:08:11 CST Organization: Raytheon Company 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@raytheon.com Raytheon Systems Company Voice (972)575-4595 Fax (972)575-5544