在oracle中regexp_like(VALID_STR ,'^[+-]?\d+(\.\d)?\d*$'); 是用来正数字的,中文用new Regex("[\u4e00-\u9fa5]+", RegexOptions.Compiled);来处理
在oracle中regexp_like(VALID_STR ,'^[+-]?\d+(\.\d)?\d*$'); 是用来正数字的,中文用new Regex("[\u4e00-\u9fa5]+", RegexOptions.Compiled);来处理
在oracle中regexp_like(valid_str ,'^[+-]?d+(.d)?d*$'); 是用来正数字的,中文用new regex("[u4e00-u9fa5]+", regexoptions.compiled);来处理
create or replace function isnumber(valid_str in varchar2) return number is cursor valid_number is select 1 from dual where regexp_like(valid_str ,'^[+-]?d+(.d)?d*$'); isnumber_ valid_number%rowtype; begin open valid_number; fetch valid_number into isnumber_; if (valid_number%found) then close valid_number; return 1; else close valid_number; return 0; end if; end isnumber;
解决正则中文
public static int getlength(string strsource)
{
regex regex = new regex("[u4e00-u9fa5]+", regexoptions.compiled);
int nlength = strsource.length;for (int i = 0; i {
if (regex.ismatch(strsource.substring(i, 1)))
{
nlength++;
}
}return nlength;
}
