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字符串拆分轉義?
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