bjyxszd_nsdd的博客

原创 oracle 一行拆多行

SELECT requestid,apply_content 申请内容,regexp_substr(flow_attachment, '[^,]+', 1, level) p_requestid,procurement_mode 采购方式,level FROM formtable_main_483 where flow_attachment is not nullconnect by level <=regexp_count(flow_attachment,'\,')+1 and ro.