select regexp_replace(a,'[0-9]*') from( select '123' a from dual union all select '12a' from dual union all select 'a3c ' from dual union all select 'abc' from dual)
用正则表达式。。select col from tb where regexp_like(col,'[[:alpha:]]');
10g可以支持regex。9i可以试试用translate select replace(translate(a,'0123456789', '#'), '#', '') from( select '123' a from dual union all select '12a' from dual union all select 'a3c ' from dual union all select 'abc' from dual)不过规则复杂的就不行了。
select '123' a from dual
union all select '12a' from dual
union all select 'a3c ' from dual
union all select 'abc' from dual)
10g可以支持regex。9i可以试试用translate
select replace(translate(a,'0123456789', '#'), '#', '') from(
select '123' a from dual
union all select '12a' from dual
union all select 'a3c ' from dual
union all select 'abc' from dual)不过规则复杂的就不行了。