原字段：123:345:567
想取345 该怎么写
参考https://blog.csdn.net/u011675334/article/details/102556607/
select trim(substr(replace('123:345:567',':',lpad(' ',40,' ')),30,30)) as t from dual
SELECT
SUBSTR (
字段,
INSTR (字段, ':', 1, 1) + 1,
INSTR (字段, ':', 1, 2) - INSTR (字段, ':', 1, 1)-1
) AS 字段名
FROM
TABLE
1min目标场景问卷
立即参与
