Re: What is (+) in where clause

"Maximus" <qweqwe_at_qwqwewq.com> wrote:

>"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
>news:9lu2ivon3ko205r7pn3njef38t5dlhim30_at_4ax.com...
>> On Fri, 25 Jul 2003 15:39:32 GMT, "Maximus" <qweqwe_at_qwqwewq.com>
>> wrote:
>>
>> >It's an obsoleted outer join operator, I think particualr to Oracle.
>>
>> There is nothing obsolete to it, and it is part of the sql standard.
>> Go get your school money back
>
>It's not standard SQL it's an Oracle extension. This could be why Oracle
>refers it as the "Oracle join operator." This is a rather proprietary term
>for something that you claim is an SQL standard. Oracle also does not
>recommend using the (+) operator in favour of the left [outer] join syntax
>because of numerous restrictions.
>

You seem a little quick to provide partially true info... Oracle did not support the use of LEFT OUTER ( or RIGHT OUTER) JOIN statements until Version9 - Any users that are not at that version ( and millions are not) would find your answer very confusing.. Received on Fri Jul 25 2003 - 14:51:46 CDT