with t as (select '1234567890' a from dual union all select '111111111111111' a from dual union all select '111111222222' a from dual union all select '111abc111d1124' a from dual union all select 'abc$$@#@' a from dual) select * from t where not regexp_like(t.a, '+[^[:digit:]$]+')
用一个select语句实现最好,这个比较麻烦
难道我用的不是一个select语句 吗?
select * from t where not regexp_like(t.a, '+[^[:digit:]$]+')with里面的内容只是一个临时表,相当于举个例子给你看结果的。select 用上面这句就可以了,把表换成你自己的。建议拿了别人的结果最好先自己执行一下看看。然后再来理解相关内容。
(select '1234567890' a
from dual
union all
select '111111111111111' a
from dual
union all
select '111111222222' a
from dual
union all
select '111abc111d1124' a
from dual
union all
select 'abc$$@#@' a from dual)
select * from t where not regexp_like(t.a, '+[^[:digit:]$]+')
难道我用的不是一个select语句 吗?