RE: ANSI SQL Compliance (Oracle vs. SQL Server)

2001-05-04 Thread paquette stephane
Finally Oracle uses the case statement in 8i but the decode is not dead yet... Watch for the new sql command in 9i : upsert (the wedding of insert and update) --- "Mohan, Ross" <[EMAIL PROTECTED]> a écrit : > Walt, > > RTF SQL Reference M. I recall seeing a pretty good > section in there ab

RE: ANSI SQL Compliance (Oracle vs. SQL Server)

2001-05-03 Thread Jamadagni, Rajendra
Hi, I don't think Oracle is *fully* compliant, but compared to others (except for DB/2) it fairly compliant. According to Oracle's own document, O8iR2 is fully compliant at entry-level. In addition to full compliance at the Entry level, Oracle complies partially at the Transitional, Intermediate,

RE: ANSI SQL Compliance (Oracle vs. SQL Server)

2001-05-03 Thread Mohan, Ross
Walt, RTF SQL Reference M. I recall seeing a pretty good section in there about ANSI SQL92, and Oracle's superset of it. Also the Concepts Manual hth Ross || -Original Message- || From: Walter K [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 03, 2001 12:41 PM || To: Multiple