/SQL/Plsql check for string in numeric

Plsql check for string in numeric

Plsql check for string in numeric

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

0

Source: orafaq.com

Similar codes

0 vote171 views2 answers
Postgres default user
SQL
5 votes176 views1 answer
Oracle get foreign keys on table
SQL
0 vote186 views1 answer
Oracle chain step succeeded
SQL
0 vote172 views1 answer
Oracle show grants on table
SQL
0 vote175 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote175 views1 answer
Difference between min and max date sql
SQL
0 vote164 views1 answer
Back up stored procedures mysql
SQL
0 vote175 views1 answer
Sql comand for removing data from table
SQL
1 vote196 views1 answer
How to set up a trigger in sql
SQL
5 votes166 views1 answer
Oracle asynchronous query
SQL

Share