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

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 17 Jun 2006 14:46:34 -0700
Message-ID: <1150580797.442124@bubbleator.drizzle.com>

Galen Boyer wrote:
> 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.

Many of us have been doing full out joins in the standard Oracle syntax for years such as the following:

select * from (

   select v.vessel_id
   from vessels v, trips t
   where v.vessel_id = t.vessel_id(+)
   union
   select t.vessel_id
   from vessels v, trips t
   where v.vessel_id(+) = t.vessel_id);

Not as pretty but certainly easy.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Jun 17 2006 - 16:46:34 CDT