감사합니다.

기존에 도움을 주셔서 잘 사용하고 있었습니다. 그런데 요번 프로젝트에서 feature의 글자수가 다른 경우가 발생해서 아래 첨부한 이미지의 빨간 박스 처럼 문제가 생겼습니다. 혹시 다른 방안이 있을까요?

아래 부분을 실행하면 첨부한 이미지 처럼 값이 나옵니다.

WITH usage AS
(
SELECT 1 no, 'AAEKZ OR AAED3' usage   FROM dual
UNION ALL SELECT 2, 'AAEKZ OR AAED3-TX'  FROM dual
UNION ALL SELECT 3, 'AAEA7 AND KBE00' FROM dual
UNION ALL SELECT 4, 'AAEA7 AND KBE00' FROM dual
)
, model_varaint AS
(
SELECT 'MEST23DRW' modelVariant, 'AAEKZ' feature, 'S' value FROM dual
UNION ALL SELECT 'MEST23DRW'  , 'AAED3', 'O' FROM dual
UNION ALL SELECT 'MEST23DRW'  , 'AAED3-TX', 'O' FROM dual
UNION ALL SELECT 'MEST23DRW'  , 'AAEA7', 'O' FROM dual
UNION ALL SELECT 'MEST23DRW'  , 'KBE00', 'S' FROM dual
UNION ALL SELECT 'MEST23DRW'  , 'KBE01', 'S' FROM dual
UNION ALL SELECT 'MEST23DRW'  , 'KBE02', '-' FROM dual
UNION ALL SELECT 'MEST23DRW'  , 'AAEB5', '-' FROM dual
UNION ALL SELECT 'MEST23DRW'  , 'AAED2', 'S' FROM dual
UNION ALL SELECT 'OKLIDDS21AD', 'AAEKZ', 'S' FROM dual
UNION ALL SELECT 'OKLIDDS21AD', 'AAED3', 'S' FROM dual
UNION ALL SELECT 'OKLIDDS21AD', 'AAEA7', '-' FROM dual
UNION ALL SELECT 'OKLIDDS21AD', 'KBE00', '-' FROM dual
UNION ALL SELECT 'OKLIDDS21AD', 'KBE01', 'S' FROM dual
UNION ALL SELECT 'OKLIDDS21AD', 'KBE02', '-' FROM dual
UNION ALL SELECT 'OKLIDDS21AD', 'AAEB5', '-' FROM dual
UNION ALL SELECT 'OKLIDDS21AD', 'AAED2', 'S' FROM dual
UNION ALL SELECT 'DFR55EW'    , 'AAEKZ', 'S' FROM dual
UNION ALL SELECT 'DFR55EW'    , 'AAED3', 'S' FROM dual
UNION ALL SELECT 'DFR55EW'    , 'AAEA7', 'S' FROM dual
UNION ALL SELECT 'DFR55EW'    , 'KBE00', 'S' FROM dual
UNION ALL SELECT 'DFR55EW'    , 'KBE01', 'S' FROM dual
UNION ALL SELECT 'DFR55EW'    , 'KBE02', 'S' FROM dual
UNION ALL SELECT 'DFR55EW'    , 'AAEB5', '-' FROM dual
UNION ALL SELECT 'DFR55EW'    , 'AAED2', 'S' FROM dual
)
, mv_code AS    
(
SELECT 1 mv_seq, 'MEST23DRW' modelVariant FROM dual
UNION ALL SELECT 2, 'OKLIDDS21AD' FROM dual
UNION ALL SELECT 3, 'DFR55EW'     FROM dual
)
, tmp1 AS
(
SELECT no, usage
     , modelvariant, feature, value
     , COUNT(*) OVER(PARTITION BY no) cnt
     , ROW_NUMBER() OVER(PARTITION BY no ORDER BY feature) rn
  FROM (SELECT a.no, a.usage
             , b.modelvariant, b.feature, b.value
             , DENSE_RANK() OVER(PARTITION BY b.feature ORDER BY a.no) dr
             , c.mv_seq                        
             , MAX(c.mv_seq) OVER() max_seq    
          FROM usage a
             , model_varaint b
             , mv_code c                       
         WHERE INSTR(a.usage, b.feature) > 0 
           AND b.modelvariant = c.modelvariant 
        )
 WHERE mv_seq = (MOD(dr - 1, max_seq) + 1)     
)
select * from tmp1
;