Re: Going mad - outer join problem
Date: Mon, 20 Oct 2008 19:16:56 +0100
"Jeremy" <jeremy0505_at_gmail.com> wrote in message news:MPG.23665ada8d94c88198968a_at_News.Individual.NET...
> In article <48FB79A2.7010505_at_gmail.com>, mdemenko_at_gmail.com says...>
>> select *
>> from a,
>> where a.id = b.id (+)
>> and nvl(b.code(+),'TYPE') = 'TYPE'
>> order by a.id;
> is the right answer. Thanks and also to David and Serge for their help.
> When I was taught SQL by oracle I don't recall there ever being
> references to e.g. "LEFT OUTER JOIN" - it was all the (+) notation.
> I guess they are methods to achieve the same objective but what are the
> pros and cons?
Oracle has had the ISO join syntax since version 9i. The ISO syntax is a standard used by almost all other DBMSs whereas the (+) syntax is peculiar to Oracle. The ISO syntax also supports FULL OUTER JOIN for which there is no simple equivalent in the older Oracle syntax.
-- David PortasReceived on Mon Oct 20 2008 - 13:16:56 CDT