SELECT  '대리점가' a
FROM dual
   UNION ALL
   SELECT agent_pri*1.1 a
       FROM SD_PART_MAST
   WHERE part_no = RPAD('TH56380000S1',12,' ')
   UNION ALL
    SELECT  repair_store_pri*1.1 a
       FROM SD_PART_MAST
   WHERE part_no = RPAD('TH56380000S1',12,' ')
   UNION ALL
    SELECT real_buyer_pri a
       FROM SD_PART_MAST
   WHERE part_no = RPAD('TH56380000S1',12,' ')

중간중간 빨갛게 쓴 저 이름을 추가 하려고 했는데
금액이랑 형이 달라서 오류가 나네여~

-- 저라면 컬럼 두개(항목구분, 항목값)로 조회하겠습니다.
SELECT DECODE(lv, 1, '대리점가', 2, '수리점가', 3, '실수요자가') gb
     , DECODE(lv, 1, agent_pri, 2, repair_store_pri, 3, real_buyer_pri) v
  FROM sd_part_mast
     , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 3)
 WHERE part_no = RPAD('TH56380000S1',12,' ')
 ORDER BY lv
;
-- 컬럼 하나로 하시려면
SELECT DECODE(lv, 1, '대리점가'
                , 2, TO_CHAR(agent_pri*1.1)
                , 3, '수리점가'
                , 4, TO_CHAR(repair_store_pri*1.1)
                , 5, '실수요자가'
                , 6, TO_CHAR(real_buyer_pri)
                ) v
  FROM sd_part_mast
     , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 6)
 WHERE part_no = RPAD('TH56380000S1',12,' ')
 ORDER BY lv
;

참 감사합니다~ 감사감사