oracle 冒泡排序法

教主弄的，过来分享一下，注意：listagg从11.2版本开始用。希望大家努力学习哦

SQL> with xo as
  2  (select '4563531' as str from dual)
  3  select listagg(substr(str,LEVEL,1)) within GROUP (ORDER BY substr(str,LEVEL,1))
  4  FROM xo
  5  CONNECT BY LEVEL <=LENGTH(str);


LISTAGG(SUBSTR(STR,LEVEL,1))WITHINGROUP(ORDERBYSUBSTR(STR,LEVEL,1))
--------------------------------------------------------------------------------
1334556