WITH a AS
(
SELECT 1 seq, 10 t1 FROM dual
UNION ALL SELECT 2, 12 FROM dual
UNION ALL SELECT 3, 30 FROM dual
UNION ALL SELECT 4, 99 FROM dual
)
, b AS
(
SELECT 10 s, 13 e, 'AA' v FROM dual
UNION ALL SELECT 15,  19, 'BB' FROM dual
UNION ALL SELECT 20, 100, 'CC' FROM dual
UNION ALL SELECT 90, 110, 'DD' FROM dual
)
SELECT a.seq, a.t1
     , MIN(v) v_min
     , MAX(v) v_max
     , LISTAGG(v, ',') WITHIN GROUP(ORDER BY v) v_agg
  FROM a
     , b
 WHERE a.t1 BETWEEN b.s AND b.e
 GROUP BY a.seq, a.t1
 ORDER BY a.seq
;

건수가 상당하네요.
성능이 나올까 걱정되네요.

마농님 감사합니다..^^ 패러럴로 어떻게 되지 않을까 싶네요...;