Convert '           2.32204861111111E-02' to Float in Oracle...

Posted on 2009-04-16
Last Modified: 2013-12-18
I need to be able to convert a text string like...
'           2.32204861111111E-02'
To a float value in Oracle. I'll load the value into a staging table, so I'm looking for something like...

Select to_number(my_varchar,'9D9999999E99') from my_table

Which will return the float value.

Thanks for your help...

Question by:gswitz
    LVL 23

    Accepted Solution

    Try to_number()
    LVL 2

    Expert Comment

    my_varchar is a string :

    Select cast( my_varchar AS float ) from my_table return a float number

    Author Comment


    Look, there's the nose in front of my face! Who knew!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now