Oracle Chinese and digital Regular Expression instance code

In oracle, regexp_like (VALID_STR, '^ [+-]? \ D + (\. \ d )? \ D * $ '); is used to process positive numbers. Use new Regex ("[\ u4e00-\ u9fa5] +", RegexOptions. Compiled) in Chinese.

In oracle, regexp_like (valid_str, '^ [+-]? D + (. d )? D * $ '); is used for positive numbers, Chinese with 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;

Solve regular Chinese

Public static int getlength (string strsource)
{
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;
}