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博客 ” ，链接：https://blog.itpub.net/44413/viewspace-745779/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
