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