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

From: <dgoulet_at_vicr.com>
Date: Thu, 03 May 2001 10:20:16 -0700
Message-ID: <F001.002F8B06.20010503101146@fatcity.com>

Walter,

    There are several, as I remember it 4, levels of compliance with the ANSI SQL Standard. If I remember it right they range from Entry Level (minimum compliance) to Fully Compliant With Extensions with a couple in between. I believe, someone can correct me if I'm wrong, MicroSoft SQL*Server is only Entry Level compliant while DB2/Informix and Oracle are Fully Compliant With Extensions. I believe Sybase is Level 3 compliant meaning they have no extensions. Level 2 I believe is fully compliant without a procedural interface.

Dick Goulet

____________________Reply Separator____________________
Author: Walter K <alden14004_at_yahoo.com>
Date:       5/3/2001 8:41 AM

Which RDBMS is more ANSI SQL compliant, Oracle or MS SQL Server?

I have some frustrated SQL Server developers that only understand how to write inner and outer joins using SQL Server's syntax. Don't DB2, Informix and Sybase use the same method of defining joins as predicates?

Just curious. Maybe I'm crazy.
-w

---

Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Walter K
  INET: alden14004_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 03 2001 - 12:20:16 CDT