Spell Number: Convert Number into words
How can you convert a number into words using Oracle
Sql Query?
How can I spell number?
Means:
12 = Twelve
102 = One Hundred Two
1020 = One Thousand Twenty
12.12
= twelve point twelve
Here’s a classy query which will convert number into
words but this technique is having limitations which is discussed later
in this topic .Please see the query below:
select to_char(to_date(:number,'j'),'jsp') from dual;
If I pass 134 in number, then the output will : one hundred thirty-four
SELECT...
