Oracle数据 行转列
时间：2021-07-01 10:21:17
帮助过：37人阅读
cs.standard_id,cs.area_code,cs.exu_dept,
regexp_substr(exu_dept, ‘[^,]+‘,
1,
level)
as dept_id
from ca_stand_exu_dept cs
connect by
id = prior id
and instr(exu_dept
||‘,‘,
‘,‘,
1,
level)
> 0
and prior dbms_random.value
is not null;
Oracle数据 行转列
标签：regex pre standard level str sel val 记录 bst
