oracle之比较难的sql

select
        sd1.label as "1",
       t.financier as "2",
       sd2.label as "3",
       t.scale as "4",
       t.month_remaining_scale as "5",
       t.start_date as "6",
       t.end_date as "7",
       t.asset_rate as "8",
       t.check_cost as "9",
       t.mid_bus_income as "10",
       t.cur_deposit_profit as "11",
       t.reg_deposit_profit as "12",
       t.other_deposit_profit as "13",
       sd3.label as "14",
       sd4.label as "15",
  (
    select wm_concat(label) from sys_dict
    where type='dri_slowReleaseType'
    and value in (
        select regexp_substr(t.risk_slow_release,'[^,]+',1,rownum)
        from dual
        connect by length(t.risk_slow_release)-
        length(replace(t.risk_slow_release,',',''))+1>rownum
    )
  ) as "风险缓控方式",
  t.slow_release_money as "风险缓控金额（元）",
  t.col_number ,
  t.remarks
 
 from
t_driving_revenue t
left join sys_dict sd1
on sd1.type = 'capitalFromType' and sd1.value = t.capital_from
left join  sys_dict sd2
on sd2.type ='dri_productType' and sd2.value = t.product_type
left join sys_dict sd3
on sd3.type = 'dri_fiveClass' and sd3.value =t.five_class
left join  sys_dict sd4
on  sd4.type = 'YES_NO' and sd4.value =t.is_occupy_assets
left join sys_dict sd5
on  sd5.type='dri_slowReleaseType' and sd5.value = t.slow_release_type
where t.start_date < to_date('2017-01-01:00:00:00','yyyy-MM-dd hh24:mi:ss')