sql - Left Outer Join using + sign in Oracle 11g - Stack Overflow

TableA LEFT OUTER JOIN TableB is equivalent to TableB RIGHT OUTER JOIN Table A. In Oracle, (+) denotes the "optional" table in the JOIN. So in your first query, it's a P LEFT OUTER JOIN S. In your second query, it's S RIGHT OUTER JOIN P. They're ...

stackoverflow.com