Oracle regexp_like 查询包含特定字符的字符串

1、查询包含 空格、6、7、*或者#等特殊字符的字符串

SELECT * FROM (
SELECT 'AB12 3' AS data from dual UNION ALL
SELECT 'ABC*' AS data  from dual UNION ALL
SELECT 'ABC-#$' AS data  from dual UNION ALL
SELECT '456' AS data   from dual UNION ALL
SELECT '7' AS data  from dual 
) WHERE  REGEXP_LIKE(data, '([[:space:]]|[6-7]|[*]|[#])+')

查询结果

AB12 3
ABC*
ABC-#$
456
7

查询字符串是否是纯数字

select CASE WHEN regexp_like(X,'^[0-9]*$') THEN 1 ELSE 0 END IS_NUMBER , X  
from  (select '1' AS X from dual  UNION ALL 
     select '1abc2' AS X from dual 
)

结果：

IS_NUMBER	  X
1	          1
0	          1abc2