Sql

Search

oracle check numeric

SELECT CASE
           WHEN trim(translate(col1, '0123456789-,.', ' ')) IS NULL
               THEN 'numeric'
           ELSE 'other'
           END
FROM table_name;

Comment

PREVIOUS	NEXT

Code Example
Sql :: age postgres
Sql :: operator does not exist: integer = text
Sql :: sql comment header
Sql :: oracle set date format
Sql :: how to check nls timestamp format in oracle
Sql :: sql random sampling per group
Sql :: mysql add comment to column
Sql :: output to file mysql
Sql :: mysql user permission database
Sql :: mysql breakline on string
Sql :: oracle split string
Sql :: connect mysql docker
Sql :: mysql modify default value
Sql :: mysql add 2 hours
Sql :: sql string_agg
Sql :: date_add mysql
Sql :: mysql search like order by best match
Sql :: sql query length of string the longest
Sql :: find most frequent value in sql column
Sql :: sql select only time from datetime
Sql :: postgres convert text to number
Sql :: mysql time ago difference
Sql :: date 3 months from today sql
Sql :: access mysql command mac xampp
Sql :: mysql how to subtract dates
Sql :: mysql create table like
Sql :: mysql incrementation
Sql :: array out of range mql4
Sql :: oracle undo usage by session
Sql :: clear a table in mysql

Search

SQL

oracle check numeric

ADD CONTENT