甲骨文声明 [英] Oracle statement

问题描述

表记录如下

D:\HOME\DOC\FILE\2001\12\TT-12S2Q99-EE-EE1.pdf  
D:\HOME\DOC\FILE\2002\02\TT-12S2Q94-EE-EE1.xml  
D:\HOME\DOC\FILE\2005\05\TT-12S2Q98-EE-EE1.pdf  
D:\HOME\DOCS\TEMPFILE\TT-12S2Q88-EE-EE1.pdf  

我只想提取那些文件名.结果应为

I want to extract those file names only. The result should be

TT-12S2Q99-EE-EE1    
TT-12S2Q94-EE-EE1   
TT-12S2Q98-EE-EE1    
TT-12S2Q88-EE-EE1

有人可以帮我吗?

推荐答案

第三个可以使用 INSTR 否定参数，以从末尾开始向后搜索字符串(直到几分钟前我才知道您可以执行此操作).将其与SUBSTR结合使用，您将拥有所需的内容:

You can use INSTR with the third parameter negative to search backwards in the string from the end (something I didn't know you could do until a few minutes ago). Combine that with a SUBSTR and you should have what you want:

SQL> select filename from mytable;

FILENAME
--------------------------------------------------------------------------------
C:\path\to\some\file.txt

SQL> select substr(filename, instr(filename, '\', -1) + 1) from mytable;

SUBSTR(FILENAME,INSTR(FILENAME,'\',-1)+1)
--------------------------------------------------------------------------------
file.txt

这篇关于甲骨文声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！