0

I have a oracle query statement.

SELECT *
FROM   TABLE1 sc, TABLE2 sr
WHERE  sc.TABLE_ID(+)='T1000'   
AND    sc.TABLE_VALID(+)='Y'  
AND    sc.TABLE_VALUE(+)=sr.STATUS
  • What is (+) next to each column name in where clause?
  • What (+) is doing in this oracle select query?
  • What's the difference with or without (+) in this query?

I executed this query with or without (+), but couldn't see any difference in query results. I googled it, but couldn't find a clear answer.

user2761895
  • 1,431
  • 4
  • 22
  • 38
  • 1
    You might find this interesting: [Difference between Oracle's plus (+) notation and ansi JOIN notation?](http://stackoverflow.com/questions/1193654). – mason Dec 12 '14 at 20:23
  • (+) is basically an `outer join`, you should search using `OUTER JOIN` instead – Aramillo Dec 12 '14 at 20:28

0 Answers0