Oracle - Convert Numbers to Character Strings in Oracle

Convert Numbers to Character Strings in Oracle

Q

How To Convert Numbers to Character Strings in Oracle?

✍: FYIcenter.com

A

You can convert numeric values to characters by using the TO_CHAR() function as shown in the following examples:

SELECT TO_CHAR(4123.4570) FROM DUAL
123.457

SELECT TO_CHAR(4123.457, '$9,999,999.99') FROM DUAL
     $4,123.46

SELECT TO_CHAR(-4123.457, '9999999.99EEEE') FROM DUAL
 -4.12E+03

⇒Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 292👍, 0💬

Popular Posts:

Import One Table bac...

How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...

Error: Imported Tabl...

What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...

CAST() - Converting ...

How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...

What Is Microsoft SQ...

What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...

SQL Server Database ...

Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...