Order By Clause-MS to Oracle Conversion

From: <afedirko_at_my-deja.com>
Date: Wed, 23 Aug 2000 18:46:09 GMT
Message-ID: <8o165a$5n4$1@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 - 13:46:09 CDT