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, 2052🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...