- [0-9] 表示
- 0123456789
- [^0-9] 表示
- 非数字的任意字符
- sql> select * from emp2;
- DATA
- --------------------------------------------------
- SMITH800
- ALLEN1600
- WARD1250
- JONES2975
- MARTIN1250
- BLAKE2850
- CLARK2450
- SCOTT3000
- KING5000
- TURNER1500
- ADAMS1100
- DATA
- --------------------------------------------------
- JAMES950
- FORD3000
- MILLER1300
- 已选择14行。
- select regexp_replace(data,'[^0-9]',''),regexp_replace(data,'[0-9]','') FROM emp2
- [^0-9] 将被数字的替换为空
- [0-9] 将数字替换为空