Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

plsql check for string in numeric

SELECT case when regexp_like(col1, '^d+(.d+){0, 10}?$') 
            then 'numeric'
            else 'alfa'
      end
FROM  tab1;
Source by www.orafaq.com #
 
PREVIOUS NEXT
Tagged: #plsql #check #string #numeric
ADD COMMENT
Topic
Name
8+2 =