How to pick only Numeric values from oracle table.
642949Jun 3 2008 — edited Jun 4 2008I have a column which contains both numeric and alphanumeric data. I want to fetch only the numeric data from that column.
table have data like:
1a
1
2
d2
f
My query should return only 1,2 not any other value.Any help in this matter is higly appreciated.
Thanks