Re: Any experience converting MSSQL apps to Oracle?

I would add one more important thing:
You may have stored procedures returning recordsets (like a common select) in MS SQL.
Oracle does not provide this feature.

Malcontent <malcontent_at_msgto.com> wrote in message news:38E2FECB.6EF1C639_at_msgto.com...
> > 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