Re: Order By Clause-MS to Oracle Conversion

From: Rognvald Bjarne <wear_u_out_at_nospam.hotmail.com>
Date: Wed, 23 Aug 2000 13:43:01 -0600
Message-ID: <POVo5.206$uzc7.2752892@news.randori.com>

Decode?

<afedirko_at_my-deja.com> wrote in message news:8o165a$5n4$1_at_nnrp1.deja.com...
> When converting a database from MS SQL Server 7 to Oracle 8x, I
> discovered that the Order By Clause behaves differently between the two
> databases. When I do an Order By in SQL Server, a null will appear
> before a field with a character. When in Oracle, it is the opposite.
>
> It is very important to get the same resultset from both databases, as
> the Application can point to either one. Besides placing a space
> character instead of a null, do I have any other option for
> accomplishing this sort in Oracle?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 23 2000 - 14:43:01 CDT