What does oracle (+) operator do?

jiminator

[H]F Junkie
Joined
Feb 2, 2007
Messages
11,618
Ya, I googled it. Google does not handle parenthesis or + very well. I also can't find anything in looking through SQL Docs

context :
SELECT DISTINCT C1.X, C1.Y
FROM C1, A1,
WHERE A1.DN = 'xxx'
AND A1.DN = C1.DN(+) ;

thanks guys.
 
Last edited:

mikeblas

[H]ard|DCer of the Month - May 2006
Joined
Jun 26, 2004
Messages
12,775
It's archaic and non-standard syntax for OUTER JOIN.

The statement you wrote is better written as:

Code:
SELECT DISTINCT C1.X, C1.Y
  FROM C1
  OUTER JOIN A1 ON A1.DN = C1.DN
WHERE A1.DN = 'xxx';
 
Top