/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

-2 votes233 views2 answers
Sqlserver docker
SQL
1 vote249 views1 answer
Continue in sql
SQL
0 vote227 views1 answer
How to change the field size of an existing column
SQL
0 vote225 views1 answer
Mysql find db contarint
SQL
0 vote223 views1 answer
How much table store postgres
SQL
3 votes245 views1 answer
Oracle list user grants
SQL
7 votes243 views2 answers
Sql empty table
SQL
0 vote251 views3 answers
Constraint sql
SQL
15 votes247 views5 answers
If null mysql
SQL
0 vote456 views1 answer
Power bi connect to postgresql
SQL

Share