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, 3544🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How Many Groups of Data Types in MySQL? MySQL support 3 groups of data types as listed below: String...