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');
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');
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/44413/viewspace-745779/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/44413/viewspace-745779/