How To Convert Number into Words using Oracle SQL Query
How to resolve the following issue using SQL -- spell the number?
---------------------------------------------------------------------------
Given 132, Return "One Hundred Thirty-Two"
Given 102355, Return "One Hundred Two Thousand Three Hundred Fifty-Five"
----------------------------------------------------------------------------
Using the following trick "j and jsp" ---
select to_char(to_date(:number,'j'),'jsp') from dual
Check it out here
http://viralpatel.net/blogs/convert-number-into-words-oracle-sql-query/
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1407603857650
--------------------------------------
Regards,
FangwenYu
![](https://pic.cnblogs.com/avatar/93867/20191016181427.png)