Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> What's the meaning of (+)?
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 (+) Received on Wed Aug 15 2001 - 17:28:05 CDT