SELECT SUBSTR('/filesRoot/resourceFile/cd706ea94dad11b4a05255e80d1d00b0.ppt',
1,
INSTR('/filesRoot/resourceFile/cd706ea94dad11b4a05255e80d1d00b0.ppt',
'.',
-1) - 1) AS FILE_NAME
FROM DUAL;
得到:/filesRoot/resourceFile/cd706ea94dad11b4a05255e80d1d00b0