WITH basic AS
(
SELECT 1 no, 12080 family, 12689 feature FROM dual
UNION ALL SELECT  2, 12080, 12690 FROM dual
UNION ALL SELECT  3, 12090, 12811 FROM dual
UNION ALL SELECT  4, 12090, 12812 FROM dual
UNION ALL SELECT  5, 12134, 12687 FROM dual
UNION ALL SELECT  6, 12134, 12688 FROM dual
UNION ALL SELECT  7, 12134, 12986 FROM dual
UNION ALL SELECT  8, 12134, 12987 FROM dual
UNION ALL SELECT  9, 12134, 12988 FROM dual
UNION ALL SELECT 10, 12135, 12989 FROM dual
UNION ALL SELECT 11, 12135, 12990 FROM dual
UNION ALL SELECT 12, 12135, 12991 FROM dual
UNION ALL SELECT 13, 12135, 12992 FROM dual
UNION ALL SELECT 14, 12135, 12993 FROM dual
UNION ALL SELECT 15, 12135, 12994 FROM dual
UNION ALL SELECT 16, 12135, 12995 FROM dual
UNION ALL SELECT 17, 12135, 12996 FROM dual
UNION ALL SELECT 18, 12135, 12997 FROM dual
UNION ALL SELECT 19, 12135, 12998 FROM dual
UNION ALL SELECT 20, 12135, 12999 FROM dual
UNION ALL SELECT 21, 12146, 13049 FROM dual
UNION ALL SELECT 22, 12146, 13050 FROM dual
UNION ALL SELECT 23, 12221, 15010 FROM dual
UNION ALL SELECT 24, 12221, 15011 FROM dual
UNION ALL SELECT 25, 12234, 16031 FROM dual
UNION ALL SELECT 26, 12234, 16034 FROM dual
UNION ALL SELECT 27, 12234, 16036 FROM dual
UNION ALL SELECT 28, 12234, 16037 FROM dual
)
-- resultA --
SELECT no, family, feature
     , LISTAGG('b' || id) WITHIN GROUP(ORDER BY id) id
     , LISTAGG(node) WITHIN GROUP(ORDER BY id) node
     , seq
     , DECODE(cnt, 1, '', '(') ||
       LISTAGG(DECODE(node, 1, '', '!') || 'b' || id, '&&') WITHIN GROUP(ORDER BY id)
       || DECODE(cnt, 1, '', ')') NodeId
  FROM (SELECT no, family, feature
             , cnt, seq, lv
             , DENSE_RANK() OVER(ORDER BY family, lv DESC) - 1 id
             , SIGN(BITAND(seq, POWER(2, lv-1))) node
          FROM (SELECT no, family, feature
                     , COUNT(*) OVER(PARTITION BY family) - 1 cnt
                     , ROW_NUMBER() OVER(PARTITION BY family ORDER BY no) - 1 seq
                  FROM basic
                )
             , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 9)
         WHERE POWER(2, lv-1) <= cnt
        )
 GROUP BY no, family, feature, cnt, seq
;

SET DEFINE OFF;

WITH basic AS
(
SELECT 1 no, 12080 family, 12689 feature FROM dual
UNION ALL SELECT  2, 12080, 12690 FROM dual
UNION ALL SELECT  3, 12090, 12811 FROM dual
UNION ALL SELECT  4, 12090, 12812 FROM dual
UNION ALL SELECT  5, 12134, 12687 FROM dual
UNION ALL SELECT  6, 12134, 12688 FROM dual
UNION ALL SELECT  7, 12134, 12986 FROM dual
UNION ALL SELECT  8, 12134, 12987 FROM dual
UNION ALL SELECT  9, 12134, 12988 FROM dual
UNION ALL SELECT 10, 12135, 12989 FROM dual
UNION ALL SELECT 11, 12135, 12990 FROM dual
UNION ALL SELECT 12, 12135, 12991 FROM dual
UNION ALL SELECT 13, 12135, 12992 FROM dual
UNION ALL SELECT 14, 12135, 12993 FROM dual
UNION ALL SELECT 15, 12135, 12994 FROM dual
UNION ALL SELECT 16, 12135, 12995 FROM dual
UNION ALL SELECT 17, 12135, 12996 FROM dual
UNION ALL SELECT 18, 12135, 12997 FROM dual
UNION ALL SELECT 19, 12135, 12998 FROM dual
UNION ALL SELECT 20, 12135, 12999 FROM dual
UNION ALL SELECT 21, 12146, 13049 FROM dual
UNION ALL SELECT 22, 12146, 13050 FROM dual
UNION ALL SELECT 23, 12221, 15010 FROM dual
UNION ALL SELECT 24, 12221, 15011 FROM dual
UNION ALL SELECT 25, 12234, 16031 FROM dual
UNION ALL SELECT 26, 12234, 16034 FROM dual
UNION ALL SELECT 27, 12234, 16036 FROM dual
UNION ALL SELECT 28, 12234, 16037 FROM dual
)
, ruleifthen AS
(
SELECT 1 no, '&12688' rule_exp1, '&13049/15010' rule_exp2      FROM dual
UNION ALL SELECT 2, '&12986/12687'      , '&13050/15011'       FROM dual
UNION ALL SELECT 3, '&12988'            , '&13050/15011&16031' FROM dual
UNION ALL SELECT 4, '&12988&12689&12811', '&12998'             FROM dual
UNION ALL SELECT 5, '&12687&12689&12811', '&12999'             FROM dual
UNION ALL SELECT 6, '&12997'            , '&16034'             FROM dual
UNION ALL SELECT 7, '&16036'            , '&13050&15010/16037' FROM dual
)
, resultA AS
(
SELECT no, family, feature
     , LISTAGG('b' || id) WITHIN GROUP(ORDER BY id) id
     , LISTAGG(node) WITHIN GROUP(ORDER BY id) node
     , seq
     , DECODE(cnt, 1, '', '(') ||
       LISTAGG(DECODE(node, 1, '', '!') || 'b' || id, '&&') WITHIN GROUP(ORDER BY id)
       || DECODE(cnt, 1, '', ')') NodeId
  FROM (SELECT no, family, feature
             , cnt, seq, lv
             , DENSE_RANK() OVER(ORDER BY family, lv DESC) - 1 id
             , SIGN(BITAND(seq, POWER(2, lv-1))) node
          FROM (SELECT no, family, feature
                     , COUNT(*) OVER(PARTITION BY family) - 1 cnt
                     , ROW_NUMBER() OVER(PARTITION BY family ORDER BY no) - 1 seq
                  FROM basic
                )
             , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 9)
         WHERE POWER(2, lv-1) <= cnt
        )
 GROUP BY no, family, feature, cnt, seq
)
-- ruleResult --
SELECT a.no
     , a.rule_exp1
     , a.rule_exp2
     , '(' || a.rule_exp3 || ') && (' ||
       SUBSTR(
       LISTAGG(SUBSTR(a.rule_exp2, INSTR(a.rule_exp2, b.feature)-1, 1) || b.nodeid)
             WITHIN GROUP(ORDER BY INSTR(a.rule_exp2, b.feature)), 2)
       || ')' rule_exp3
  FROM (SELECT a.no
             , a.rule_exp1
             , a.rule_exp2
             , SUBSTR(
               LISTAGG(SUBSTR(a.rule_exp1, INSTR(a.rule_exp1, b.feature)-1, 1) || b.nodeid)
                     WITHIN GROUP(ORDER BY INSTR(a.rule_exp1, b.feature)), 2) rule_exp3
          FROM ruleifthen a
             , resulta b
         WHERE INSTR(a.rule_exp1, b.feature) > 0
         GROUP BY a.no, a.rule_exp1, a.rule_exp2
        ) a
     , resulta b
 WHERE INSTR(a.rule_exp2, b.feature) > 0
 GROUP BY a.no, a.rule_exp1, a.rule_exp2, a.rule_exp3
;

정말 감사합니다. 구정 잘 보내세요.

실제 사용하다보니 한가지 다른 부분을 발견했습니다.

table : ruleResult 의 첫번째 결과가 ((!b2&&!b3&&b3)) && (!b9/!b10) 이어야 하는데 ((!b2&&!b3&&b3)) && (!b9&&!b10)로 결과가 나옵니다.

수고하세요.

맞습니다. 역시 마농님 이시네요. 감사합니다.