Re: What does the (+) mean?

From: FlameDance <flamedance_at_gmx.de>
Date: Fri, 06 Feb 2004 15:25:26 +0100
Message-ID: <c008a3$ec4$00$1@news.t-online.com>

Milan Smederevac wrote:
>>I have an SQL with the following line in the WHERE clause:
>>
>>CLR.REF1=SEASON.RCIDX(+)
>>

> 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).

This one I understood and used. Additional question: How can I create a full outer join?

WHERE CLR.REF1(+)=SEASON.RCIDX(+) is not allowed by the compiler.

I found a workaround writing some PL/SQL code but is there a way to do it directly?

Stephan Received on Fri Feb 06 2004 - 08:25:26 CST