You are here:

Oracle/Invalid Number Error

Advertisement


Question
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
Kevin

Answer
Hi Kevin,

When you run the select statement,

SELECT TO_NUMBER(BB.mileage) Mileage1
FROM BB;

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?

Peter

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Peter Choi

Expertise

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).

©2016 About.com. All rights reserved.