ANSI join syntax and Oracle 8i
Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, etc.) was backported to 8i? Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 join syntax and Oracle 8i
Sunday, December 21, 2003, 7:14:27 PM, Grant Allen ([EMAIL PROTECTED]) wrote: GA> Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, GA> etc.) was backported to 8i? No, it was not. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 join syntax and Oracle 8i
> -Original Message- > From: Jonathan Gennick [mailto:[EMAIL PROTECTED] > Sent: Monday, 22 December 2003 11:59 > To: Multiple recipients of list ORACLE-L > Subject: Re: ANSI join syntax and Oracle 8i > > > Sunday, December 21, 2003, 7:14:27 PM, Grant Allen > ([EMAIL PROTECTED]) wrote: > GA> Does anyone know if the ANSI join syntax (LEFT OUTER > JOIN, RIGHT OUTER JOIN, instead of (+) =, > GA> etc.) was backported to 8i? > > No, it was not. > > Best regards, Thanks Jonathan - I had a feeling that was the case, just making sure. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 join syntax and Oracle 8i
I don't, but perhaps Lex does? He's crazy about that Join stuff and even has a whole one-day class on mathematical methods in SQL. Also, he has written a book on SQL, that still sells well - but it's in Dutch, so you'd have to learn that language first :). Lex - welcome to the Oracle-L list :). I hope you can help Grant with his question? Best regards, Mogens Grant Allen wrote: Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, etc.) was backported to 8i? Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).