Oracle - Convert Numbers to Character Strings in Oracle

Convert Numbers to Character Strings in Oracle

How To Convert Numbers to Character Strings in Oracle?

✍: FYIcenter.com

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

2020-03-25, 780👍, 0💬

Popular Posts:

AdventureWorksLT Ent...

How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...

Running Queries with...

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

Error: Imported Tabl...

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

AND, OR, XOR, and NO...

What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...

CREATE TABLE - Creat...

How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...