Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle outer join syntax (+) not working???

Re: Oracle outer join syntax (+) not working???

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 17 Jun 2006 16:25:04 -0500
Message-ID: <upsh7z4jg.fsf@rcn.com>


On 17 Jun 2006, REMOVE_BEFORE_REPLYING_dportas_at_acm.org wrote:

> What suprises me is that Oracle's (+) syntax still seems to be
> common. Given the important advantages of the standard syntax (full
> joins; non-equijoins; well-defined evaluation order; portability) it's
> odd that it doesn't seem to have gained the universal acceptance in
> the Oracle world the way it has done elsewhere.

Once I found out that FULL outer join is supported but a full outer join isn't supported with the (+) syntax, I switched to INNER JOIN, LEFT/RIGHT/FULL OUTER JOIN syntax. Haven't looked back.

-- 
Galen Boyer
Received on Sat Jun 17 2006 - 16:25:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US