DB 공통명령어
SELECT A.MN_MDUL_CD
,A.MI_CD_VEHL_CD ||' : '||Sf_Cd_Val_Nm('15212', MI_CD_VEHL_CD) AS MI_CD_VEHL_CD
,A.PRDN_PLNT_CD
,Sf_Cd_Val_Nm('15212',A.MDUL_SCN_CD) AS KKK
,A.FIRM_CD
,A.APL_STRT_CDT
,A.APL_FNH_CDT
,B.FIRM_NM
FROM HAMA_WVOMMDFM A
,T_DLVG_FIRM_INFO B
WHERE A.MN_MDUL_CD = '1'
AND A.FIRM_CD = B.PART_FIRM_CD(+)
오라클 전용 명령어..
SELECT A.MN_MDUL_CD
,A.MI_CD_VEHL_CD ||' : '||Sf_Cd_Val_Nm('15212', MI_CD_VEHL_CD) AS MI_CD_VEHL_CD
,A.PRDN_PLNT_CD
,Sf_Cd_Val_Nm('15212',A.MDUL_SCN_CD) AS KKK
,A.FIRM_CD
,A.APL_STRT_CDT
,A.APL_FNH_CDT
,B.FIRM_NM
FROM HAMA_WVOMMDFM A LEFT OUTER JOIN T_DLVG_FIRM_INFO B
ON A.FIRM_CD = B.PART_FIRM_CD
WHERE A.MN_MDUL_CD = '1'
SELECT A.MN_MDUL_CD
,A.MI_CD_VEHL_CD ||' : '||Sf_Cd_Val_Nm('15212', MI_CD_VEHL_CD) AS MI_CD_VEHL_CD
,A.PRDN_PLNT_CD
,Sf_Cd_Val_Nm('15212',A.MDUL_SCN_CD) AS KKK
,A.FIRM_CD
,A.APL_STRT_CDT
,A.APL_FNH_CDT
,B.FIRM_NM
FROM HAMA_WVOMMDFM A
,T_DLVG_FIRM_INFO B
WHERE A.MN_MDUL_CD = '1'
AND A.FIRM_CD = B.PART_FIRM_CD(+)
오라클 전용 명령어..
SELECT A.MN_MDUL_CD
,A.MI_CD_VEHL_CD ||' : '||Sf_Cd_Val_Nm('15212', MI_CD_VEHL_CD) AS MI_CD_VEHL_CD
,A.PRDN_PLNT_CD
,Sf_Cd_Val_Nm('15212',A.MDUL_SCN_CD) AS KKK
,A.FIRM_CD
,A.APL_STRT_CDT
,A.APL_FNH_CDT
,B.FIRM_NM
FROM HAMA_WVOMMDFM A LEFT OUTER JOIN T_DLVG_FIRM_INFO B
ON A.FIRM_CD = B.PART_FIRM_CD
WHERE A.MN_MDUL_CD = '1'