17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT substr('SMMAL_220_01HR_20110620_014_000.xml',instr('SMMAL_220_01HR_20110620_014_000.xml','_',1,3)+1,8) as cdate from dual;
CDATE
----------------
20110620
--自己替换下字符串。
[SYS@myorcl] SQL>SELECT SUBSTR('SMMAL_220_01HR_20110620_014_000.xml',
2 INSTR('SMMAL_220_01HR_20110620_014_000.xml', '_', 1, 3) + 1,
3 INSTR('SMMAL_220_01HR_20110620_014_000.xml', '_', 1, 4) -
4 INSTR('SMMAL_220_01HR_20110620_014_000.xml', '_', 1, 3) - 1) C
5 FROM DUAL
6 ;
C
--------
20110620