I am mostly a SQL Server guy. I inherited an Oracle problem that involves a query structure that uses WHERE clauses as joins, rather than JOIN statements.
SELECT * FROM
po_distributions_all pod
, pa_projects_all pap
WHERE
pod.project_id = pap.project_id(+)
I understand this to be an outer join. The question is, which direction? Is this a (pod LEFT OUTER pap) or a (pod RIGHT OUTER pap) or (pap LEFT OUTER pod) or (pap RIGHT OUTER pod) join?
How do I decipher the indicator?
Thanks.