SELECT no, text
     , MIN(DECODE(v, 5, cnt)) cnt5, MIN(DECODE(v, 5, rat)) rat5
     , MIN(DECODE(v, 4, cnt)) cnt4, MIN(DECODE(v, 4, rat)) rat4
     , MIN(DECODE(v, 3, cnt)) cnt3, MIN(DECODE(v, 3, rat)) rat3
     , MIN(DECODE(v, 2, cnt)) cnt2, MIN(DECODE(v, 2, rat)) rat2
     , MIN(DECODE(v, 1, cnt)) cnt1, MIN(DECODE(v, 1, rat)) rat1
  FROM (SELECT no, text, v
             , COUNT(*) cnt
             , RATIO_TO_REPORT(COUNT(*)) OVER(PARTITION BY no) rat
          FROM (SELECT a.no, a.text
                     , DECODE(a.no, 1, b.a1
                                  , 2, b.a2
                                  , 3, b.a3
                                  -- ... 이하 생략 ... --
                                  ) v
                  FROM (질의문) a
                     , (설문내용) b
                )
         GROUP BY no, text, v
        )
 GROUP BY no, text
 ORDER BY no
;

감사합니다. 덕분에 잘 해결 되었습니다 ^^