How to select only numbers from a varchar column???
I have a column that is varchar2(10). It is a mix of numeric
and alphanumeric values.
Col1
-----
1
F
10
RAC
PROMO
20
30
I want to only select rows that have a numeric value
select col1
from mytable
where col1 is numeric;
col1
---
1
10
20
30
Any Ideas??