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

Home -> Community -> Usenet -> c.d.o.misc -> Re: What's the meaning of (+)?

Re: What's the meaning of (+)?

From: Mark D Powell <mark.powell_at_eds.com>
Date: 16 Aug 2001 06:33:53 -0700
Message-ID: <178d2795.0108160533.1af33bb3@posting.google.com>


Karsten Wutzke <karsten.wutzke_at_starconcept.com> wrote in message news:<3B7AF775.F7EA56C8_at_starconcept.com>...
> Hi all!
>
> What's the meaning of a "(+)" after a comparison in a WHERE statement?
>
>
> SELECT p.PNR, k.KIND
> FROM PERSONAL p, KIND k
> WHERE p.pnr = k.PNR(+) AND p.PNR < 130
>
> I've just stumbled across it in the exam preparations, but I can't find
> it documented somewhere in my papers.
>
> Thanks for helping!
>
> Karsten
>
> PS: PERSONAL is PERSONELL or EMPLOYEES, KIND is CHILD
>
> Sorry for dupe... I forgot the essential (+)

The (+) symbol is Oracle's notation for an outer join, which Oracle supported before the ANSI standard included the operation. Rows with the plus return null rows when the matching condition test fails so that the other table will receive a match and therefore always return a row. I understand that version 9i will support the ANSI inner and outer join syntax.

Received on Thu Aug 16 2001 - 08:33:53 CDT

Original text of this message

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