Hello All,
Any comparison analysis and usage preference of ANSI SQL over Conventional SQL?
ANSI SQL
SELECT
CLAI.ID AS CLA_CLAIMS_ID,
PBT.CODE AS BRAND_CODE,
PBT.DESCR AS BRAND_DESCR,
OIEB.CODE AS PERSON_CODE,
RR.FIRST_NAME AS PERSON_FIRST_NAME
FROM CLAIMS CLAI
INNER JOIN BRANDS_B PBB ON PBB.ID=CLAI.BRAN_ID
INNER JOIN BRANDS_TL PBT ON PBT.BASE_TABLE_ID=PBB.ID
LEFT OUTER JOIN INSURABLE_ENTITIES OIEB ON OIEB.ID=CLAI.INSE_ID
INNER JOIN REL_RELATIONS RR ON RR.CODE=OIEB.CODE
WHERE PBT.language='en'
AND RR.subtype='PERS'
AND CLAI.START_DATE=TO_DATE('01/01/2017','DD/MM/YYYY')
Conventional SQL
SELECT
CLAI.ID AS CLA_CLAIMS_ID,
PBT.CODE AS BRAND_CODE,
PBT.DESCR AS BRAND_DESCR,
OIEB.CODE AS PERSON_CODE,
RR.FIRST_NAME AS PERSON_FIRST_NAME
FROM CLAIMS CLAI ,
BRANDS_B PBB ,
BRANDS_TL PBT,
INSURABLE_ENTITIES OIEB ,
REL_RELATIONS RR
WHERE PBT.language='en'
AND RR.subtype='PERS'
AND CLAI.START_DATE=TO_DATE('01/01/2017','DD/MM/YYYY')
and PBB.ID=CLAI.BRAN_ID
and PBT.BASE_TABLE_ID=PBB.ID
and OIEB.ID(+)=CLAI.INSE_ID
and RR.CODE=OIEB.CODE
Thanks,
Rajneesh