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, 1554🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...