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 Numbers to Characters?

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

Go down

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

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

How To Convert Numbers to Characters?
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

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