How To Convert Number into Words using Oracle SQL Query

2023-11-14 05:30•Android•阅读 1567

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