Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Translate JOIN syntax from LEFT JOIN, RIGHT JOIN to (+)

594752Oct 5 2007 — edited Oct 5 2007
I have looked through a lot of documentation, but have yet to see some concreate examples of how to code a JOIN when you are used to LEFT, RIGHT JOIN, etc.
Could someone translate these, removing the LEFT OUTER JOIN, etc. and replace with the (+). I am fairly new to Oracle and have been using the others all along?

SELECT *
FROM LOCATION L
LEFT OUTER JOIN DEPT D
ON (L.LocationID = D.LocationID)
LEFT OUTER JOIN EMPLOYEE E
ON (D.DeptID = E.DeptID);

SELECT *
FROM EMPLOYEE E
RIGHT OUTER JOIN DEPT D
ON (D.DeptID = E.DeptID)
RIGHT OUTER JOIN LOCATION L
ON (L.LocationID = D.LocationID);

SELECT *
FROM LOCATION L
FULL JOIN DEPT D
ON (L.LocationID = D.LocationID)
FULL JOIN EMPLOYEE E
ON (D.DeptID = E.DeptID);

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2007
Added on Oct 5 2007
4 comments
6,537 views