/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

1 vote396 views1 answer
Sql server read uncommitted
SQL
0 vote349 views1 answer
Install sql server windows 10
SQL
0 vote377 views1 answer
Oracle list of long running queries
SQL
0 vote352 views2 answers
SQL Server Standard
SQL
0 vote345 views1 answer
Postgres copy command
SQL
2 votes354 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote369 views3 answers
How to run sql query
SQL
19 votes364 views6 answers
What is mySQL
SQL
0 vote399 views1 answer
Traccar mysql
SQL
0 vote365 views1 answer
Sql date d'aujourd'hui
SQL

Share