当前位置：网站首页>How Oracle converts strings into multiple lines

How Oracle converts strings into multiple lines

2022-07-22 19:44:00 【Yabingshi】

# Will use / Separate strings are converted to multiple lines

with a as (select '/ABC/AA/AD/ABD/JI/CC/ALSKD/ALDKDJ' id from dual)
select regexp_substr(id,'[^/]+',1,rownum) id from a
connect by rownum<=length(regexp_replace(id,'[^/]+'))

The effect is as follows ：

 

# Empathy , Convert comma separated strings to multiple lines

-- This article is for reference About oracle To convert a string to multiple lines - it610.com 

原网站

版权声明
本文为[Yabingshi]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/203/202207221003230369.html

边栏推荐

猜你喜欢

随机推荐