Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is (+) in where clause

Re: What is (+) in where clause

From: Maximus <qweqwe_at_qwqwewq.com>
Date: Fri, 25 Jul 2003 19:29:18 GMT
Message-ID: <iyfUa.514275$ro6.12064633@news2.calgary.shaw.ca>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US