SELECT  

id01,

HEBING,

case when t.HEBING is null then id01 else  SUBSTR(HEBING,1,INSTR(t.HEBING,'''')-1)  end as 前面,

trim(replace(substr(replace(HEBING,',',lpad(' ',40,' ')) ,15,35),chr(39),''))  as 中间,

trim(replace(substr(replace(HEBING,',',lpad(' ',40,' ')) ,70,35),chr(39),''))  as 最后

 from QRQC_TRACK_REPORT FOR UPDATE

---------------------重新补充答案2022-07-23，以前没有写的语句由于没有模拟数据没有做测试现在重新模拟数据做测试参考如下，你报错的语句是oracel，那么oracel的语句参考如下----------------------

模拟的数据类似如下和你图片一样：

最后生成的语句

SELECT 

id01,

HEBING,

case when t.HEBING is null then to_char(id01) 

when INSTR(t.HEBING,'''')=0 then t.HEBING else  SUBSTR(HEBING,1,INSTR(t.HEBING,'''')-1)  end as 前面,

trim(replace(substr(replace(HEBING,',',lpad(' ',40,' ')) ,15,35),chr(39),''))  as 中间,

trim(replace(substr(replace(HEBING,',',lpad(' ',40,' ')) ,70,35),chr(39),''))  as 最后

from (

select 1 as id01,'5'||''','''||4 as HEBING from dual

union all

select 2 as id01,null as HEBING from dual

union all

select 3 as id01,'5'||''','''||4||''''||','||'6' as HEBING from dual

union all

select 4 as id01,'6' as HEBING from dual

) t