Need pl sql program for converting numbers into words

Question

hi,

I need to convert the numbers into words. for example: i have a 10 digit mobile number as 9876543210, I wat to convert this into 'NINE EIGHT SEVEN SIX FIVE FOUR THREE TWO ONE ZERO or as NINETY EIGHT CORES SEVENTY SIX LAKHS .....etc. without USING JSP IN THE QUERY. PLEASE HELP ME IN THIS TO write a SQL Query or PL-SQL program for this concept.

Answer 1

you need to extract those numbers from the database. and use a switch satatment . to convert them .
to get the data you need PHP . it would be something like this.
- connect to database
-retrieve the column for numbers
- convert the string of numbers to an array.
- iterate through the array
- switch (array[index]) inside the above loop
ex: switch (array[index]){
case 0 : somevarialble ='zero';
break;
case 1 : somevariable ='one';
etc.
you can store those somevariable in an array instead.