SELECT requestid
,apply_content 申请内容
,regexp_substr(flow_attachment, '[^,]+', 1, level) p_requestid
,procurement_mode 采购方式
,level
FROM formtable_main_483
where flow_attachment is not null
connect by level <=regexp_count(flow_attachment,'\,')+1 and rowid = prior rowid
and prior dbms_random.value > 0
oracle 一行拆多行
于 2021-08-09 11:49:37 首次发布