Oracle determines whether it is a numeric or numeric string (sqlserver isnumeric)

Requirements:

If the field value is not a numeric or numeric string, update the field value''

1. Function Method (batch release is not allowed ):

[SQL]

1. CreateOrReplaceFunctionIsNumber (p_in varchar2)ReturnBooleanAs
2. I number;
3. Begin
4. I: = to_number (p_in );
5. ReturnTrue;
6. Exception
7. WhenOthersThen
8. ReturnFalse;
9. End;

However, it seems that this can only be judged one by one and cannot be performed in batches.

2.

[SQL]

1. SQL>SelectNvl2 (translate ('123','\ 100','\'),'IsCharacters','IsNumber ')FromDual;
3. NVL2 (TRANSLATE ('123', '\ 1234567
4. ------------------------------
5. IsNumber
7. SQL>SelectNvl2 (translate (333,'\ 100','\'),'IsCharacters','IsNumber ')FromDual;
9. NVL2 (TRANSLATE (333, '\ 123456789
10. ------------------------------
11. IsNumber
13. SQL>SelectNvl2 (translate ('Aaaaa','\ 100','\'),'IsCharacters','IsNumber ')FromDual;
15. NVL2 (TRANSLATE ('Aaaaa', '\ 12345
16. ------------------------------
17. IsCharacters
19. SQL>

3. It is said that batch query is required. You can check it out first, but you have not tried it:

[SQL]

1. SelectDecode (nvl2 (translate (Column,'\ 100','\'),'0','1'),'1', Column ,'')FromDual;

I wrote:

[SQL]

1. UpdateT_87_MtbufSetSpCode ='' WhereNvl2 (translate (SpCode,'\ 100','\'),'IsCharacters','IsNumber') ='IsCharacters ';

Add:

To_number (...) can only accept numbers such as 122 or numeric string '123456'. If 'aaa' is accepted, an error "invalid character" is returned ".