Basic Oracle Concepts and Programming Question:
How To Convert Characters to Numbers in Oracle?
Answer:
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
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
| Previous Question | Next Question |
| How To Convert Numbers to Characters in Oracle? | How To Convert Dates to Characters in Oracle? |