Select TRANSLATE(列名,TRANSLATE(列名, '0123456789', ' '),' ') as Numbers from 表名 ;
--测试 Select TRANSLATE(col,TRANSLATE(col, '0123456789', ' '),' ') as nums from ( Select '一电厂111开关' as col from dual Union Select '小店222开关' from dual Union Select '杨家堡1234开关' from dual Union Select '新赵家山812虚拟开关' from dual ) t ;--结果 NUMS ------ 111 222 1234 812
from 表名 ;
from ( Select '一电厂111开关' as col from dual Union
Select '小店222开关' from dual Union
Select '杨家堡1234开关' from dual Union
Select '新赵家山812虚拟开关' from dual ) t ;--结果
NUMS
------
111
222
1234
812