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 meaning for "(+)" in Oracle SQL?

Re: what's meaning for "(+)" in Oracle SQL?

From: Keld Nielsen <keldnielsen_at_image.dk>
Date: Mon, 6 May 2002 19:35:05 +0200
Message-ID: <yczB8.13323$HZ2.969194@news000.worldonline.dk>


according to docs:
...
from table1, table2
where table1.column(+) = table2.column;
...
from table1, table2
where table1.column = table2.column(+);
...
can be placed on either side of the where clause, but not on both sides (place the outer join symbol following the name of the column in the table without the matching rows.)
...

"Dan" <crystal_jd_at_hotmail.com> wrote in message news:d9cc6a3a.0205040949.146d274a_at_posting.google.com...
> what's meaning for "(+)" in Oracle SQL?
>
> Thanks
Received on Mon May 06 2002 - 12:35:05 CDT

Original text of this message

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