create table aa (aa varchar2(20));
insert into aa values ('221324');
insert into aa values ('23kkj23');
insert into aa values ('asfsf');
insert into aa values ('33DS32sd34');
用下面SQL就可以查出
select * from aa
where aa!=translate(aa,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz','0123456789');
最初由 OL.O 发布
[B]create table aa (aa varchar2(20));
insert into aa values ('221324');
insert into aa values ('23kkj23');
insert into aa values ('asfsf');
insert into aa values ('33DS32sd34');
用下面SQL就可以查出
select * from aa
where aa!=translate(aa,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz','0123456789'); [/B]
上面没考虑为空
select * from aa
where aa!=nvl(translate(aa,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz','0123456789'),1);