Re: Any experience converting MSSQL apps to Oracle?

From: PRINCIPE Francesco <francesco.principe_at_cmisdn.inet.it>
Date: 2000/03/31
Message-ID: <8c2aut$lj2$1@lacerta.tiscalinet.it>#1/1

You shoul pay attenction to enother thing. The following two select in MSSQL Server give the same result set

Select * from emp where empno=null ----- Select * from emp where empno is null

in Oracle if you what all rows with empno = null, you have to perform the second select

john becker <jbecker_at_netcom.ca> wrote in message news:BayE4.18519$Xk2.75561_at_tor-nn1.netcom.ca...
> Our app currently runs on NT4 with MSSQL.
> We use very straight forward SQL and the
> most complicated feature we use is stored
> procs.
>
> We are happy with MSSQL, etc. - but wouldn't
> you know - we have a prospect that wants the
> app to use Oracle.
>
> I've ordered the $200 developers kit and it's on
> its way from Oracle - but in the meantime has
> anyone tried this and what is the effort involved?
> Any gotchas you would like to share?
>
> Thanks -John
>
>
Received on Fri Mar 31 2000 - 00:00:00 CST