oracle 逗号分割,列转行
时间:2021-07-01 10:21:17
帮助过:5人阅读
REGEXP_SUBSTR(a.rolecode ,‘[^,]+‘,
1,l)
rolecode
from (
select ‘a,aa,aaa‘ rolecode
from dual
) a,
(SELECT LEVEL l
FROM DUAL CONNECT
BY LEVEL<=100) b
WHERE l
<=LENGTH(a.rolecode)
- LENGTH(
REPLACE(rolecode,
‘,‘))
+1
oracle 逗号分割,列转行
标签: