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 does the (+) mean?

Re: What does the (+) mean?

From: Milan Smederevac <smeky_at_gmx.net>
Date: Mon, 2 Feb 2004 23:25:25 +0100
Message-ID: <bvmicm$uv$1@news.eunet.yu>


> I have an SQL with the following line in the WHERE clause:
>
> CLR.REF1=SEASON.RCIDX(+)
>
> What does the (+) mean?

That is right JOIN, in other words outer JOIN meaning return all rows including that one that are NULL in SEASON table (showing all rows from CLR table). Received on Mon Feb 02 2004 - 16:25:25 CST

Original text of this message

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