Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Order By Clause-MS to Oracle Conversion
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