Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle outer join syntax (+) not working???
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 BoyerReceived on Sat Jun 17 2006 - 16:25:04 CDT
![]() |
![]() |