oracle 正则表达式 替换 ‘’：

select /*+ parallel(8) */
t.name as 报表名称,
t4.umid as 上报人UM,
t4.created_date as 上报时间,
t4.updated_date,
t4.state,
t4.eoa_session_id,
t3.base_path,
t6.deptid_descr,
dbms_lob.substr(
REGEXP_REPLACE(replace(substr(t4.query_condition,
                               instr(t4.query_condition, 'collspanpoint=') + 14,
                               instr(t4.query_condition,
                                     '}',
                                     instr(t4.query_condition,
                                           'collspanpoint=')) -
                               instr(t4.query_condition, 'collspanpoint=') - 13),
                        '''',
                        ''),
                '[[:alpha:]]+\:',
                '')
                )
--dbms_lob.substr( substr(t4.query_condition,instr(t4.query_condition,'collspanpoint=')+14,  instr(t4.query_condition,'}',instr(t4.query_condition,'collspanpoint='))-instr(t4.query_condition,'collspanpoint=')-13))
  from parp_report_info t,
       parp_report_module t3,
       parp_report_eoa_session_detail t4,
       (select a.login_username, a.dept_code
          From (select /*+ parallel(8) */
                 l.login_username,
                 l.dept_code,
                 row_number() over(partition by l.login_username order by l.created_date desc) as ordernum
                  From parp_user_login_log l
                 where l.dept_code is not null) a
         where a.ordernum = 1) t5,
       parp_paic_dept_info t6
where t.id_report_info = t4.id_report_info(+)
   and t.id_report_module = t3.id_report_module(+)
   and t4.umid = t5.login_username
   and t5.dept_code = t6.paic_unique_deptid
   and (t3.base_path like '寿险数据采集%' or t3.base_path like '金管家数据采集%' or
       t3.base_path like '行销数据采集%')
   and to_char(t4.created_date, 'yyyy-MM-dd') >= '2017-07-01'
   and to_char(t4.created_date, 'yyyy-MM-dd') <= '2018-06-30'
   and t4.state = 'Y'
  
order by t4.created_date desc