oracle存储过程中怎么做逗号分隔
展开全部
select rn
REGEXP_SUBSTR(a, '[^,]+', 1, LEVEL) STR
from (select a,rownum rn from t)
CONNECT BY LEVEL <= REGEXP_COUNT( a, ',') + 1
and rn= prior rn
and prior dbms_random.value is not null;
REGEXP_SUBSTR(a, '[^,]+', 1, LEVEL) STR
from (select a,rownum rn from t)
CONNECT BY LEVEL <= REGEXP_COUNT( a, ',') + 1
and rn= prior rn
and prior dbms_random.value is not null;
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
