Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is (+) in where clause
"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. Received on Fri Jul 25 2003 - 14:29:18 CDT
![]() |
![]() |