xianxingg/_.sql

Created March 3, 2016 10:37

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/xianxingg/c058c5cc72a6f00e574b.js"></script>
Save xianxingg/c058c5cc72a6f00e574b to your computer and use it in GitHub Desktop.

Download ZIP

From http://stackoverflow.com/questions/15677446/how-to-tweak-listagg-to-support-more-than-4000-character-in-select-query listagg不用做escape（date），但是xmlagg需要转码，否则报错： datatype， describeCol

Raw

_.sql

dbms_xmlgen.convert(xmlagg(xmlelement(E, name||',')).extract('//text()').getclobval(),1)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment