回覆列表
  • 1 # a不會愛的小笨蛋

    取最後一個\後面的字元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

  • 中秋節和大豐收的關聯?
  • 自釀葡萄酒的危害,你瞭解多少?