instr ,substr,TO_DATA

1.instr('源字符串','目标字符串’，'开始位置','第几次出现')函数
select instr('BRD_SOI_standard-202011120.xml','-') from dual;
--17
2、TO_DATA(substr('BRD_SOI_standard-202011120.xml',instr('BRD_SOI_standard-202011120.xml','-')+1,8)||'084000','YYYYMMDDHH24MISS')
--2020/11/12 8:40:00