ORACLE 一条记录 某字段值以';'拆分为多条记录

SELECT ID,班组,班次日期, REGEXP_SUBSTR(TIME_RANGE, '[^;]+', 1, LEVEL) TIME_RANGE
  FROM 排班表
  WHERE 1 = 1
CONNECT BY LEVEL <= REGEXP_COUNT(TIME_RANGE, ';') + 1
  AND PRIOR ROWID = ROWID
  AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL
  AND REGEXP_SUBSTR(TIME_RANGE, '[^;]+', 1, LEVEL) IS NOT NULL

上一篇:加载动画 dot_two_three_four_points_and_dot_circle


下一篇:Codeforces Round #697 (Div. 3) 简要题解