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

Popular Posts:

About dba.FYIcenter....

What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...

Running Queries with...

How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...

SQL Server Transact-...

Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

Define External Tabl...

How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...