[Oracle] Select 절에서 Select 사용하기

SELECT 절에서 SELECT 절을 사용해서 쿼리를 간단하게 작성하기. SELECT RP.CLEANING_CD, RP.SUBWORK_CD ,(SELECT CD_NM FROM FIDMS_CODE_T WHERE CD_NO = RP.CLEANING_CD) CLEANING_NM ,(SELECT CD_NM FROM FIDMS_CODE_T WHERE CD_NO = RP.SUBWORK_CD) SUBWORK_NM FROM FIDMS_PRDINSP_PLN_T RP WHERE RP.EQUNR='B1-DA101' AND PSV_ITEM_CD='PSV_T0007' AND RP.PLN_DATE LIKE '2010%'...