DB version: 11.2.0.4
I know this is an SQL question. But, I need DBAs' views on this.
My developer colleagues still write joins using old Oracle Style joins. As a DBA, I always advise them to switch to ANSI syntax.
I know that there are no performance improvments with using ANSI syntax. Its just for more readability or potential portability (to DB2 or SQL Server).
But, are there any drawbacks in using ANSI SQL with Oracle RDBMS ?
Eg1: instead of using INNER JOIN clause , they still use the following
select a.created accnt_created_on,c.created addr_associated_on
from cust_master c , account_dtl a
where region_id='APAC'
and c.accnt_id=a.row_id
and a.accnt_type_cd='INTL'
and a.SKU_FLG='Y'
and a.PKT_FLG='N'
and a.INT_ORG_FLG='N'
Eg2: Instead of using LEFT OUTER JOIN (or RIGHT OUTER JOIN) clause, they still use
SELECT org.name, pos.created, usr.usr_id
FROM siebel.s_user usr,
siebel.s_postn pos,
siebel.s_org_ext org,
siebel.s_contact con
WHERE usr.row_id=con.row_id
AND con.pr_held_postn_id = pos.row_id(+)
AND pos.ou_id = org.row_id(+)