WITH t AS
(
SELECT 1 pk, 'WCT001' prod, 'MY' color, '095' siz FROM dual
UNION ALL SELECT 2, 'WCT004', 'BK', '090' FROM dual
UNION ALL SELECT 3, 'WCT017', 'BK', '090' FROM dual
UNION ALL SELECT 4, 'WDW013', 'RE', '090' FROM dual
UNION ALL SELECT 5, 'WDW013', 'RE', '095' FROM dual
UNION ALL SELECT 6, 'WDW019', 'BE', '090' FROM dual
UNION ALL SELECT 7, 'WDW023', 'WI', '100' FROM dual
UNION ALL SELECT 8, 'WDW025', 'KH', '085' FROM dual
UNION ALL SELECT 9, 'WDW025', 'KH', '090' FROM dual
)
SELECT lv
     , REGEXP_SUBSTR(pk   , '[^,]+', 1, lv) pk
     , REGEXP_SUBSTR(prod , '[^,]+', 1, lv) prod
     , REGEXP_SUBSTR(color, '[^,]+', 1, lv) color
     , REGEXP_SUBSTR(siz  , '[^,]+', 1, lv) siz
     , CEIL(lv / 5) suit
     , MOD(lv-1, 5)+1 subsuit
  FROM (SELECT *
          FROM (SELECT LEVEL cnt
                     , SYS_CONNECT_BY_PATH(pk   , ',') pk
                     , SYS_CONNECT_BY_PATH(prod , ',') prod
                     , SYS_CONNECT_BY_PATH(color, ',') color
                     , SYS_CONNECT_BY_PATH(siz  , ',') siz
                  FROM t
                 WHERE LEVEL = (SELECT COUNT(*) FROM t)
                 --AND ROWNUM = 1 -- 원래 여기에 넣으려고 한건데, 느려서...
                 CONNECT BY NOCYCLE PRIOR pk != pk
                                AND PRIOR color != color
                )
         WHERE ROWNUM = 1 -- 여기에 넣으니 빨라지네요.
        )
     , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 999)
 WHERE lv <= cnt
;

 아,... 너무 감사합니다..

^^