Oracle ..간단한 파싱방법..

 select biz_name from htsin01.bg_biz_mst where biz_id in (
        SELECT SUBSTR (str,
                       INSTR (str, base, 1, LEVEL) + len,
                       INSTR (str, base, 1, LEVEL + 1) - INSTR (str, base, 1, LEVEL) - len) sub
          FROM (SELECT ',' base, ',' || (select min(themecode) from gws_mainsalegoods ) || ',' str,
                       LENGTH (',') len
                  FROM DUAL)
        CONNECT BY LEVEL <= (LENGTH (str) - LENGTH (REPLACE (str, base))) / len - 1
)