Simple Query which was asked me in Interview...... How to Display the Numbers in Words .......

                How to Display the Numbers in Words ......

For example in Employee Table "salary" Column is there..
Along with salary display the Employee name , salary in digits and salary in Numbers..
How can you display the salary in words.......?
Answer for that Query is.........


SELECT  ename,sal,TO_CHAR(TO_DATE(sal,"JSP"),"JSP") "Salary in Words" FROM Emp;

In this query JSP means Julian Spell out.  It will display the numbers in words by using conversion functions without using any conversion function we can not get the result.


*/

No comments:

Post a Comment