WITH t AS
(
SELECT 'AA' cd, 1 s_cnt, 3 e_cnt, 100 rat FROM dual
UNION ALL SELECT 'AA', 4,  4,  90 FROM dual
UNION ALL SELECT 'AA', 5,  5,  80 FROM dual
UNION ALL SELECT 'AA', 6, 10,  40 FROM dual
UNION ALL SELECT 'BB', 1,  1, 100 FROM dual
UNION ALL SELECT 'BB', 2,  2,  90 FROM dual
UNION ALL SELECT 'BB', 3,  7,  50 FROM dual
UNION ALL SELECT 'BB', 8,  8,  40 FROM dual
UNION ALL SELECT 'BB', 9, 15,  20 FROM dual
)
SELECT *
  FROM t
     , (SELECT LEVEL cnt FROM dual CONNECT BY LEVEL <= 99)
 WHERE cnt BETWEEN s_cnt AND e_cnt
 ORDER BY cd, cnt
;
-- http://gurubee.net/article/55635