SET DEFINE OFF;

WITH part_usage AS
(
SELECT 1 seq, 'P920' Partid, '&13131&15205&12919&15297/15296&13043/12814&13626/13625/13628' usage FROM dual
UNION ALL SELECT 2, 'P5383', '&13131&15289&22100&13647&13517&13540' FROM dual 
UNION ALL SELECT 3, 'P28'  , '&13131&15289&22100&13647&13518&13540' FROM dual
UNION ALL SELECT 4, 'P2838', '&13131&15289&22100&13648&13517&13540' FROM dual
)
, vc_feature AS
(
SELECT 'VC1' vc_id, '13213,13215,13131,13233,13147,13116,13138,15299,15264,15228,15237' feature_list FROM dual
UNION ALL SELECT 'VC2', '13213,13215,13233,13147,13116,13138,15289,13647,15299,15264,15228,15237,15205,15210,15163,15124,15142,15082,15028,14997' FROM dual
UNION ALL SELECT 'VC3', '13213,13215,13233,13147,13116,13138,15299,15264,15228,15237,15205,13540' FROM dual
)
SELECT b.vc_id
     , a.seq
     , a.Partid
     , REGEXP_REPLACE(REGEXP_REPLACE(a.usage
       , REPLACE(b.feature_list, ',', '|'), 'S')
       , '[0-9]{5}', '-') x
  FROM part_usage a
     , vc_feature b
 ORDER BY b.vc_id, a.seq
;

아침일찍 감사하게 해결해 주셨네요.

이렇게 짤끔하게 된다니 매번 신기하고 감사합니다.