SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.
SQL tutorial | Interview questions | Oracle

Database administration, oracle Interview questions, SQL Interview questions, DBMS Interview questions,SQL tutorial


How To Convert Characters to Numbers?

SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions

Go down

How To Convert Characters to Numbers? Empty How To Convert Characters to Numbers?

Post by Micheal Sat Jan 16, 2010 9:16 pm

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

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

- Similar topics

SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions

 
Permissions in this forum:
You cannot reply to topics in this forum