python 判断是否含有数字,英文字符和汉字

2025-06-23 06:08:48
推荐回答(1个)
回答1:

简单的:一条语句搞定,SqlPlus里面select decode(length(replace(translate(\\'字符串的值\\',\\'0123456789.\\',\\' \\'),\\' \\',\\'\\')),0, \\'is number\\',\\'is not a number\\') from dual; 麻烦点的:写function在oracle数据库中,create or replace function f_str_or_num(str varchar2) return varchar2 is
2 v_num number;
3 v_return varchar2(60);
4 begin
5 v_num:=to_number(str);
6 v_return:=str||\\' is a number string!\\';
7 return v_return;
8 exception when others then
9 v_return:=str||\\' is not a number string!\\';
10 return v_return;
11 end f_str_or_num; 然后调用select f_str_or_num(\\'字符串的值) from dual;