oracle字符串拆分转义

更新时间:01-24 教程 由 迷糊 分享

oracle字符串拆分转义?

wm_concat非标准函数,不保证以后会支持

标准写法:

with t as (select name,row_number() over(order by name) rn from 表)

select name, rn, sys_connect_by_path(name, ',') path

from t

start with rn=1 connect by prior rn+1=rn

声明:关于《oracle字符串拆分转义》以上内容仅供参考,若您的权利被侵害,请联系13825271@qq.com
本文网址:http://www.25820.com/tutorial/14_2182140.html