oracle 以某个字符拆分成多行
摘要:这里以#号拆分多行: SELECT cy.zjhm, REGEXP_SUBSTR(cy.jtcy, '[^#]+', 1, LEVEL) NAME FROM t_xsgl_xsgl_xsxx cy CONNECT BY LEVEL <= REGEXP_COUNT(cy.jtcy, '[^#]+')
阅读全文
posted @ 2021-08-26 20:37
posted @ 2021-08-26 20:37
posted @ 2021-08-19 10:34