1、regexp_like
SELECT * FROM (
SELECT 'ABC#$&' AS data from dual UNION ALL
SELECT 'AB123' AS data from dual UNION ALL
SELECT '456' AS data from dual UNION ALL
SELECT '7' AS data from dual
) WHERE regexp_like(data,'^[0-9]+$')
查询结果
456
7
说明
regexp_like(data,'^[0-9]+$') 纯数字。 亦可用 regexp_like(data, '^[[:digit:]]+$');
regexp_like(data,'^[0-9]{3}$') 3位纯数字
2、translate
SELECT * FROM (
SELECT 'ABC#$&' AS data from dual UNION ALL
SELECT 'AB123' AS data from dual UNION ALL
SELECT '456' AS data from dual UNION ALL
SELECT '7' AS data from dual
) WHERE translate(data, 'a0123456789', 'a') is NULL
查询结果
456
7