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
2020-03-25, 780👍, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...