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, 1500🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...