On Sat, 17 Jun 2006, damorgan_at_psoug.org wrote:
> 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.
Unions are for sissys...
--
Galen Boyer
Received on Sat Jun 17 2006 - 19:27:01 CDT
