Skip to Main Content

SQL & PL/SQL

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!

Convert string to number with decimals

user545194Sep 2 2021

Is it possible to convert this string to a number with decimals? The source is coming from an Excel file as a string like the example below.
For example:
String: 0.00389
Desired conversion as a number: 3.89

Comments

Post Details

Added on Sep 2 2021
7 comments
12,111 views