oracle中文與數字正則執行個體代碼

在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 < strsource.length; i++)
            {
                if (regex.ismatch(strsource.substring(i, 1)))
                {
                    nlength++;
                }
            }

            return nlength;
        }