字符串取值问题？

显示全部楼层 · 2007-10-20 08:38:44

如何只取字符串中的数值？比如‘afd][;/123456’我想要的结果为123456
请教这样改如何实现？

千问 · 2007-10-20 08:38:44

也可用regular expression!
SQL> select replace(translate('123a88f55577d][;/123456',
2
translate('123a88f55577d][;/123456',
3
'0123456789',
4
' '),
5
' '),
6
' ',
7
'') str
8from dual;
STR
----------------
1238855577123456
SQL>

千问 · 2007-10-20 08:38:44

regexp_replace()

千问 · 2007-10-20 08:38:44

SELECT REPLACE(substr(sys_connect_by_path(sw, ','), 2), ',')
FROM (SELECT to_number(sw) sw, rownum rn, COUNT(*) over() cnt

FROM (SELECT substr('‘afd][;/123456’我想要的结果为',

rownum,

1) sw

FROM dual

CONNECT BY LEVELselect replace(translate('123a88f55577d][;/123456',
2
translate('123a88f55577d][;/123456',
3
'0123456789',
4
' '),
5
' '),
6
' ',
7
'') str
8from dual;
STR
----------------
1238855577123456
SQL>

千问 · 2007-10-20 08:38:44

原帖由 junsansi 于 2008-6-25 15:14 发表

扫把还灌水？