Search
 
SCRIPT & CODE EXAMPLE
 

SQL

plsql check for string in numeric

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

PREVIOUS NEXT
Code Example
Sql :: pg_dump backup postgresql 
Sql :: SELECT * INTO ROW NUMBER 
Sql :: Oracle Function call - 12C 
Sql :: create dabase psql 
Sql :: psql check table fields 
Sql :: how to do a function to return row type from a table in pl/sql 
Sql :: sql grant select only 
Sql :: id desde sql 
Sql :: yesql 
Sql :: uninstall mysql centos 7 
Sql :: check the size of the tables here ordered from the biggest size 
Sql :: how to fetch highest score in minimum time using mysql 
Sql :: get last row sqlite 
Sql :: SQL Backup Only New Changes in SQL 
Sql :: mysqldump error --no-beep 
Sql :: sql datediff db2 
Sql :: pass array parameter to stored procedure c# 
Sql :: how to find median of a column sql 
Sql :: SQL LIKE With Wildcards 
Sql :: max in postgresql 
Sql :: bigquery function 
Sql :: raiserror sql 
Sql :: run sql script file and changes db name in this file using c# 
Csharp :: unity mouse lock 
Csharp :: how to get a list of processes c# 
Csharp :: c# math to radiant 
Csharp :: C# get pc language 
Csharp :: hide console window c# 
Csharp :: c# AllowSynchronousIO to true 
Csharp :: wann war der dritte weltkrieg 
ADD CONTENT
Topic
Content
Source link
Name
9+6 =