Answers for "check if a string is a number pl/sql"

check if string is a number sql

Select CASE WHEN isnumeric([fieldname]) THEN 'Valid' ELSE 'Invalid" END

Posted by: Guest on September-01-2021

plsql check for string in numeric

SELECT case when regexp_like(col1, '^d+(.d+){0, 10}?$') 
            then 'numeric'
            else 'alfa'
      end
FROM  tab1;

Posted by: Guest on May-10-2021

Code answers related to "check if a string is a number pl/sql"