You can check this by using translate function. If the return value is NULL then the input is a number else it is character or alpha numeric.
Ex:
select ('abcd', '~0123456789', '~') from dual; -- Will return a non null value
select (123, '~0123456789', '~') from dual; -- Will return a null value
select ('123', '~0123456789', '~') from dual; -- Will return a null value
select ('123a', '~0123456789', '~') from dual; -- Will return a non null value
select ('', '~0123456789', '~') from dual; -- Will return a null value. Ensure you dont pass null values. |
