Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change VARCHAR 120,34 to NUMBER

2886698Jun 2 2015 — edited Jun 2 2015

I have a flatfile that has numerous numerical columns e.g "12,000", "23", "234,65" some columns come over as string and some as numeric so i have decided to bring them all over as string then once in oracle transform to number, how can this be achieved i have tried to_number but nothing is being loaded into the number column target, what would the correct syntax be for this to happen?

VARCHAR to NUMBER column.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2015

Added on Jun 2 2015

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

3 comments

827 views