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!

left right join vs (+)

Ashu.ProgrammerApr 7 2016 — edited Jul 8 2016

Hello,

i am from MS sql server background,

I want to ask what is the best way or oracle standard way of writing query with Joins.below are my 2 queries.

in oracle r12 i have seen oracle standard queries with ( + ).

1.

SELECT EMP.EMPLOYEE_NUMBER,EMP.FULL_NAME,PA.ORGANIZATION_NAME FROM PER_ALL_PEOPLE EMP

LEFT JOIN PER_ASSIGNMENTS_V PA ON

EMP.PERSON_ID= PA.PERSON_ID

;

2.

SELECT EMP.EMPLOYEE_NUMBER,EMP.FULL_NAME,PA.ORGANIZATION_NAME FROM PER_ALL_PEOPLE EMP,

PER_ASSIGNMENTS_V PA

WHERE EMP.PERSON_ID= PA.PERSON_ID(+)

;

Thanks

This post has been answered by Nimish Garg on Apr 7 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2016
Added on Apr 7 2016
20 comments
6,198 views