You are here:

Oracle/Invalid Number Error


Hi Peter,

Hope you are doing good.

I have column (varchar2 data type) on my table which I need to convert into number data type. when I run below query, I am getting Invalid number Error

create table AA as (select BB.*, to_number(mileage) Mileage1 from BB);

My question is how can I find records in non numeric values?
Is there any easy way to find those out?

I really appreciate your help on this

Kind Regards

Hi Kevin,

When you run the select statement,

SELECT TO_NUMBER(BB.mileage) Mileage1

do you still get an error?

In your CREATE TABLE statement, are you trying to reproduce table BB with an additional column MILEAGE1 that has the mileage converted to numbers?



All Answers

Answers by Expert:

Ask Experts


Peter Choi


I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).

©2017 All rights reserved.