오라클 split













select COLUMN

      from TABLE_NAME

      where COLUMN IN(

          SELECT DISTINCT REGEXP_SUBSTR(A.B, '[^,]+', 1, LEVEL) B

          FROM (SELECT '1,2,3' B FROM DUAL A

          CONNECT BY LEVEL <= LENGTH(REGEXP_REPLACE(A.B, '[^,]+',''))+1

      );