plsql check for string in numeric code example
Example: plsql check for string in numeric
SELECT case when regexp_like(col1, '^\d+(\.\d+){0, 10}?$')
then 'numeric'
else 'alfa'
end
FROM tab1;SELECT case when regexp_like(col1, '^\d+(\.\d+){0, 10}?$')
then 'numeric'
else 'alfa'
end
FROM tab1;