select a.YAOPING,a.guigeid,a.sl,a.keshi,a.keshiid, REGEXP_SUBSTR(v_list, ‘[^,]+’, 1, lv) v_value
from (select s.keshi,s.keshiid,s.YAOPING,s.guigeid,s.sl, s.keshiid v_list from his4.deng_47 s where s.guigeid is not null) a,
(select level lv from dual connect by level < 5) b
oracle 切割字段 REGEXP_SUBSTR 用逗号分隔
最新推荐文章于 2023-11-07 16:23:07 发布