01 2024 档案

oracle逗号分割列并转成多行
摘要：-- 写法一SELECT A.*, REGEXP_SUBSTR( A.L2UNIT_NAME, '[^,]+', 1, L ) AS L2UNIT_NAME_B, L FROM JYZB_DATA_PERM A, ( SELECT LEVEL L FROM DUAL CONNECT BY LEVEL 阅读全文
posted @ 2024-01-08 17:33 systemctl1 阅读(779) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示