chakri292

 Profile Answers by chakri292 

• Feb 11th, 2012

 

Hi,
You can use regexp.

for e.g.,

Code
SELECT to_number(regexp_replace(hello123,[[:alpha:]],)) FROM dual;

Output:

--------------

123

Balapradeep

• Feb 14th, 2012

 

Code
SELECT * FROM table_name WHERE regexp_like(column_name,^[0-9]+$);

Balapradeep Reddy

 Profile Answers by Balapradeep Reddy Questions by Balapradeep Reddy

• Feb 14th, 2012

 

Code
SELECT * FROM table_name WHERE regexp_like(column_name,^[0-9]+$);

samarendra

• Apr 3rd, 2012

 

Code
SELECT column1 FROM TABLE WHERE column1 NOT LIKE %[^0-9]% 

rohitosu

 Profile Answers by rohitosu 

• Apr 3rd, 2012

 

Query is missing quotes. The corrected query is..

Code

1. SELECT * FROM table_name WHERE regexp_like(column_name,^[0-9]+$);

Sushma S

• Apr 9th, 2012

 

Code
SELECT * FROM table_name WHERE regexp_like(column_name,^[0-9]+$);

Sudipto

• Apr 17th, 2012

 

Code
SELECT * FROM table_name WHERE regexp_like (column_name, ^[0 - 9] + $);

Nisa

• Apr 17th, 2012

 

Using regexp_replace function

Code
SELECT to_number(regexp_replace(abc123efg456kjhdf,[[:alpha:]])) 


FROM dual;

Atish

• Sep 13th, 2015

 

Code
SELECT * FROM TABLE_NAME WHERE UPPER(COLUMN_NAME)=LOWER(COLUMN_NAME);

Above query will give numeric values only. Matching is done on the basis of ASCII characters. So, in case of alphanumeric values, both upper and lower ASCII values will be different while in case of numeric values, it will match.

Sayantan

• Jun 1st, 2017

 

Select length(trim(translate(string, +-.0123456789,) from table; if the value is null then its numeric