right outer joins

[DaPi]

Sorry misuk11, I can't see anything.


dharma, you're right about the placing of conditions, but in this case a better parallel is:

SELECT *
FROM   EMP e RIGHT OUTER JOIN DEPT d
  ON   e.deptno = d.deptno
WHERE  d.dname IN ('OPERATIONS','RESEARCH')

gives the same as:

SELECT *
FROM   EMP e, DEPT d
WHERE  e.deptno(+) = d.deptno
AND    d.dname IN ('OPERATIONS','RESEARCH')

but not:

SELECT *
FROM   EMP e RIGHT OUTER JOIN DEPT d
  ON   e.deptno = d.deptno AND d.dname IN ('OPERATIONS','RESEARCH')