欢迎投稿

今日深度:

ORACLE wm_concat函数,oraclewm_concat

ORACLE wm_concat函数,oraclewm_concat


wm_concat(columnName),该函数可以把列值以","号分隔起来,并显示成一行

例 : 行转列

 

SQL> select wm_concat(name) from user;

WM_CONCAT(NAME)

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

i,am,b,o,a,t

www.htsjk.Com true http://www.htsjk.com/shujukunews/7145.html NewsArticle ORACLE wm_concat函数,oraclewm_concat wm_concat(columnName),该函数可以把列以,号分隔起来,并显示成一行 例 : 行转列 SQL select wm_concat(name) from user;WM_CONCAT(NAME)-------------------------------------------------...
评论暂时关闭