SELECT SUBSTR(FIELD1,INSTR(FIELD1,'|',1,ROWNUM) + 1,ROWNUM + 1) - INSTR(FIELD1,ROWNUM) - 1) AS FIELD2 FROM (SELECT '|' || 'a|bbb|cccc|ddddd|ee|d|a' || '|' AS FIELD1 FROM DUAL) CONNECT BY INSTR(FIELD1,2,ROWNUM) > 0;
oracle 字符串转多行
dawei
2020年7月8日 22:38
SELECT SUBSTR(FIELD1, INSTR(FIELD1, |, 1, ROWNUM) + 1, INSTR(FIELD1, |, 1, ROWNUM + 1) – INSTR(FIELD1, |, 1, ROWNUM) – 1) AS FIELD2 FROM (SELECT | || a|bbb|cccc|ddddd|ee|d|a || | AS FIELD1
本文来自网络，不代表青岛站长网立场。转载请注明出处： https://www.0532zz.com/html/shujuku/oracle/20200708/5376.html
