ORACLE行转列函数

SQL> select wmsys.wm_concat(str)

  2  from  (select 'aa' as str from dual

  3         union all

  4         select 'bb' as str from dual

  5         union all

  6         select 'cc' as str from dual

  7         union all

  8         select 'dd' as str from dual

  9         union all

 10         select 'ee' as str from dual

 11         )a;

WMSYS.WM_CONCAT(STR)

-----------------------------------------------------------------------------------------------------------------------------------------------------------

aa,bb,cc,dd,ee

Elapsed: 00:00:00.51

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9999499/viewspace-706208/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9999499/viewspace-706208/