What does oracle (+) operator do?

[jiminator]

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.

 

[jimmyb]

http://stackoverflow.com/questions/517557/meaning-of-in-sql-queries

 

[mikeblas]

It's archaic and non-standard syntax for OUTER JOIN.

The statement you wrote is better written as:

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