示例如下:
用正则表达式 regexp_replace(id,'[^[:digit:]]','')来实现
SQL> select * from test;
ID
123ad45
(12)345
(12- 345
(12--345
(12 345
SQL> select regexp_replace(id,'[^[:digit:]]','') id from test;
ID
12345
12345
12345
12345
12345
示例如下:
用正则表达式 regexp_replace(id,'[^[:digit:]]','')来实现
SQL> select * from test;
123ad45
(12)345
(12- 345
(12--345
(12 345
SQL> select regexp_replace(id,'[^[:digit:]]','') id from test;
12345
12345
12345
12345
12345