General MySQL Oracle SQL Server

Convert Character Strings to Numbers in Oracle

Q

How To Convert Characters to Numbers in Oracle?

✍: FYIcenter.com

A

You can convert characters to numbers by using the TO_NUMBER() function as shown in the following examples:

SELECT TO_NUMBER('4123.4570') FROM DUAL
4123.457

SELECT TO_NUMBER('     $4,123.46','$9,999,999.99') FROM DUAL
4123.46

SELECT TO_NUMBER(' -4.12E+03') FROM DUAL
-4120

 

⇒ Convert Dates to Character Strings in Oracle

⇐ Convert Numbers to Character Strings in Oracle

⇑ Understanding SQL Language Basics for Oracle

⇑⇑ Oracle Database Tutorials

2020-03-25, 7851🔥, 0💬

General MySQL Oracle SQL Server