How can you retrieve the numeric values from varchar2 type column?

Hi Friends, One table is there. It is having varchar2 type column and this column having both numeric and alphanumeric values but I want to retrieve only numeric related values from that table. If it is possible then say the answer plz... I will wait for ur tremendous answer...

Balapradeep Reddy
Profile Answers by Balapradeep Reddy Questions by Balapradeep Reddy
Feb 10th, 2012
10
19300

Questions by Balapradeep Reddy answers by Balapradeep Reddy

SQL

Answer

Showing Answers 1 - 10 of 10 Answers

chakri292
Profile Answers by chakri292

Feb 11th, 2012
Hi,
You can use regexp.

for e.g.,
Code
 
Output:

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

123

Balapradeep

Feb 14th, 2012
Code
 

Balapradeep Reddy
Profile Answers by Balapradeep Reddy Questions by Balapradeep Reddy

Feb 14th, 2012
Code
 

samarendra

Apr 3rd, 2012
Code
 

rohitosu
Profile Answers by rohitosu

Apr 3rd, 2012

Query is missing quotes. The corrected query is..

Code

Sushma S

Apr 9th, 2012
Code
 

Sudipto

Apr 17th, 2012
Code
 

Nisa

Apr 17th, 2012
Using regexp_replace function
Code
 

Atish

Sep 13th, 2015
Code
 
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.