Collections:
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
⇒ Convert Character Strings to Numbers in Oracle
⇐ Date and Time Interval Literals in Oracle
2020-03-25, 1268👍, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...