Collections:
Convert Character Strings to Numbers in Oracle
How To Convert Characters to Numbers in Oracle?
✍: FYIcenter.com
You can convert characters to numbers by using the TO_NUMBER() function as shown in the following examples:
SELECT TO_NUMBER('4123.4570') FROM DUAL 4123.457 SELECT TO_NUMBER(' $4,123.46','$9,999,999.99') FROM DUAL 4123.46 SELECT TO_NUMBER(' -4.12E+03') FROM DUAL -4120
2020-03-25, 828👍, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
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 To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...