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, 807👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...