Re: Any experience converting MSSQL apps to Oracle?

From: Malcontent <malcontent_at_msgto.com>
Date: 2000/03/30
Message-ID: <38E2FECB.6EF1C639@msgto.com>#1/1

> Any gotchas you would like to share?

Here are two.

In Oracle you are limited to object names of 30 characters or less. If you have fields or tables with more then 30 characters you are going to suffer.

SQL server processes where clauses in a case insensitive manner. Oracle does not. In SQL server the following two queries return the same recordset.

select * from a where field="something" == select * from a where field="SomeThing"

In oracle these will return different recordsets.

I am sure there is a bunch or SQL differences too. Your code is probably full of statements containing "LEFT OUTER JOIN" which does not work in oracle. Received on Thu Mar 30 2000 - 00:00:00 CST