如何查询字段中不包含字母的值

[coolzdp]

有些记录如下
ABC32443
3424/334
33444

现在想只取出不含字母的记录如
3424/334
33444

该如何写select ?

[gelyon]

select * from  table_name where not regexp_like(col_name,'[[:alpha:]]')

[ngx20080110]

select * from table1 where not regexp_like(col1, '[a-zA-Z]');

[ngx20080110]

with tmp as
(
select 'ABC32443' col1 from dual union all
select '3424/334' col1 from dual union all
select '33444' col1 from dual)
select * from tmp
where not regexp_like(col1, '[a-z]','i');

COL1        
------------
3424/334    
33444  

[minitoy]

SQL> select 1 from dual where not regexp_like('32443','[a-z]','i');
 
         1
----------
         1
 
SQL> select 1 from dual where not regexp_like('32443a','[a-z]','i');
 
         1
----------
 
SQL> 

[心中的彩虹]

SQL> with tb as
  2  (select 'ABC32443' bm from dual union all
  3  select '3424/334' from dual union all
  4  select '33444' from dual )
  5  select bm from  tb where not regexp_like(bm,'[[:alpha:]]')
  6  /

BM
--------
3424/334
33444

[Quote=引用楼主 coolzdp 的回复:]
有些记录如下
ABC32443
3424/334
33444

现在想只取出不含字母的记录如
3424/334
33444

该如何写select ?
[/Quote]