SQL：使用WITH函数处理数据，拆分与合并列值

with t as
        (select p.nurse_record_id,seq_no,replace(p.print_data,chr(9),'#') as my_str from rcd_nurse_record_print p, rcd_nurse_record n
        where p.nurse_record_id = n.nurse_record_id(+)
        and n.nurse_record_set_id = #{recordId}),
        m as
        (select nurse_record_id,seq_no, level ll ,regexp_substr(my_str, '(.*?)(#|$)', 1, level, null, 1) t_str
        from t
        connect by level <= length(my_str)-length(replace(my_str,'#'))+1
        and prior seq_no = seq_no
        and prior nurse_record_id=nurse_record_id
        and prior dbms_random.value is not null),
        a as
        (select nurse_record_id,seq_no, max(decode(ll,1,t_str,null)) printDate,
        max(decode(ll,2,t_str,null)) printTime,
        max(decode(ll,3,t_str,null)) temperatureValue,
        max(decode(ll,4,t_str,null)) pulseValue,
        max(decode(ll,5,t_str,null)) breathValue,
        max(decode(ll,6,t_str,null)) bp,
        max(decode(ll,7,t_str,null)) painScore,
        max(decode(ll,8,t_str,null)) spo2,
        max(decode(ll,9,t_str,null)) yishi,
        max(decode(ll,10,t_str,null)) oxygen,
        max(decode(ll,11,t_str,null)) wound,
        max(decode(ll,12,t_str,null)) bloodSugar,
        max(decode(ll,13,t_str,null)) inName,
        max(decode(ll,14,t_str,null)) inSize,
        max(decode(ll,15,t_str,null)) inUnit,
        max(decode(ll,16,t_str,null)) outName,
        max(decode(ll,17,t_str,null)) outSize,
        max(decode(ll,18,t_str,null)) outUnit,