with t as (select '张晓明1' name from dual union all select '张三11' from dual union all select '11阿斯蒂芬' from dual union all select '张三芬' from dual union all select '32' from dual) select * from t where regexp_like(name, '[[:digit:]]');
with t as (select '张晓明1' name from dual union all select '张三11' from dual union all select '11阿斯蒂芬' from dual union all select '张三芬' from dual union all select '32' from dual) select * from t where regexp_like(name, '[[:digit:]]'); ++
with t as (select '张晓明1' name from dual union all select '张三11' from dual union all select '11阿斯蒂芬' from dual union all select '张三芬' from dual union all select '32' from dual) select * from t where regexp_like(name, '[[:digit:]]');谢谢!谢谢
with t as
(select '张晓明1' name
from dual
union all
select '张三11'
from dual
union all
select '11阿斯蒂芬'
from dual
union all
select '张三芬'
from dual
union all
select '32' from dual)
select * from t where regexp_like(name, '[[:digit:]]');
++
with t as
(select '张晓明1' name
from dual
union all
select '张三11'
from dual
union all
select '11阿斯蒂芬'
from dual
union all
select '张三芬'
from dual
union all
select '32' from dual)
select * from t where regexp_like(name, '[[:digit:]]');谢谢!谢谢