RE: ANSI SQL Compliance (Oracle vs. SQL Server)
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 recipients of list ORACLE-L || Subject: ANSI SQL Compliance (Oracle vs. SQL Server) || || || 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: [EMAIL PROTECTED] || || 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: [EMAIL PROTECTED] (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: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ANSI SQL Compliance (Oracle vs. SQL Server)
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, and Full levels as described in Table B-1 (including both SQL-DDL and SQL-DML). HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! * This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ANSI SQL Compliance (Oracle vs. SQL Server)
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 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 recipients of list ORACLE-L > || Subject: ANSI SQL Compliance (Oracle vs. SQL > Server) > || > || > || 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: [EMAIL PROTECTED] > || > || 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: [EMAIL PROTECTED] (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: Mohan, Ross > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).