WITH t AS
(
SELECT 31 no FROM dual
UNION ALL SELECT 32 FROM dual
UNION ALL SELECT 34 FROM dual
UNION ALL SELECT 37 FROM dual
UNION ALL SELECT 38 FROM dual
UNION ALL SELECT 40 FROM dual
UNION ALL SELECT 41 FROM dual
UNION ALL SELECT 42 FROM dual
UNION ALL SELECT 43 FROM dual
UNION ALL SELECT 44 FROM dual
UNION ALL SELECT 45 FROM dual
)
SELECT LISTAGG(MIN(no) || DECODE(COUNT(*), 1, '', '~'||MAX(no)), ',')
       WITHIN GROUP(ORDER BY MIN(no)) no_range
  FROM (SELECT no FROM t ORDER BY no)
 GROUP BY ROWNUM - no
;

마농님 정말 대단하십니다. 

뭐라 형언할수 없을정도로 대단하십니다.

어떻게 은혜를 갚아야 할지 .... 

너무 감사드립니다.