SELECT
a.dsbh,
b.jsxm,
to_char( b.csrq, ‘yyyy-mm-dd’ ) csny,
decode( b.xbm, ‘1’, ‘男’, ‘2’, ‘女’, ‘’ ) xb,
REGEXP_SUBSTR( a.zydm, ‘[^,] ‘, 1, l ) zydm --l是别名
FROM
T_DS_SB a
LEFT JOIN py_rkjs b ON b.jsbh = a.dsbh
LEFT JOIN py_xs ON py_xs.xsbh = a.yxsh
,(SELECT LEVEL l FROM DUAL CONNECT BY LEVEL<=10) b --关键
WHERE
1 = 1
AND a.zt = ‘80’
AND a.zydm LIKE ‘%,%’
and l <= LENGTH(a.zydm) -LENGTH(REPLACE(a.zydm,’,’,‘’)) --修改
关于REGEXP_SUBSTR的优化
于 2024-07-01 12:21:50 首次发布