取最後一個\後面的字元select substr("D:\AssetsManagement\resource\ehcache\test.txt",1+(select instr ("D:\AssetsManagement\resource\ehcache\test.txt","\",1,(select length("D:\AssetsManagement\resource\ehcache\test.txt") - length(replace("D:\AssetsManagement\resource\ehcache\test.txt","\","")) from dual)) from dual),length("D:\AssetsManagement\resource\ehcache\test.txt")-(select instr ("D:\AssetsManagement\resource\ehcache\test.txt","\",1,(select length("D:\AssetsManagement\resource\ehcache\test.txt") - length(replace("D:\AssetsManagement\resource\ehcache\test.txt","\","")) from dual)) from dual)) from dual如果前面D:\AssetsManagement\resource\ehcache\是固定的就直接replace了select replace("D:\AssetsManagement\resource\ehcache\test.txt","D:\AssetsManagement\resource\ehcache\","") from dual