Oracle:SQL查询返回仅包含数值的行 [英] Oracle: SQL query that returns rows with only numeric values
本文介绍了Oracle:SQL查询返回仅包含数值的行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个名为X的字段(在Oracle中为列),其值类似于"a1b2c3","abc","1ab","123","156"
I have a field (column in Oracle) called X that has values like "a1b2c3", "abc", "1ab", "123", "156"
如何编写一个SQL查询,该查询仅向我返回包含纯数值=不包含字母的X?上例中的是"123"和"156"
how do I write an sql query that returns me only the X that hold pure numerical values = no letters? from the example above would be „123" and „156"
选择X 从myTable 哪里... ??
select X from myTable where ...??
推荐答案
您可以将REGEXP_LIKE
函数用作:
SELECT X
FROM myTable
WHERE REGEXP_LIKE(X, '^[[:digit:]]+$');
样品运行:
SQL> SELECT X FROM SO;
X
--------------------
12c
123
abc
a12
SQL> SELECT X FROM SO WHERE REGEXP_LIKE(X, '^[[:digit:]]+$');
X
--------------------
123
SQL>
这篇关于Oracle:SQL查询返回仅包含数值的行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文