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, 169👍, 0💬

Popular Posts:

Downloading and Inst...

How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

CAST() - Converting ...

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

Downloading and Inst...

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

"CREATE PROCEDURE" -...

How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...