Oracle - Convert Character Strings to Numbers in Oracle

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

⇒Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 419👍, 0💬

Popular Posts:

Generating CREATE VI...

How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...

Using User Defined F...

Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...

Getting Year, Month ...

How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...

CONVERT() - Converti...

How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...

Downloading and Inst...

Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...