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
