[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%'