Convert Number to word (or text)

In many cases we need to put number in words, special when it comes to amount on Invoice or Cheque/Check. If you want to convert a number in word or in text using Oracle SQL, then you use below statment

select TO_CHAR(TO_DATE( 158 , 'J' ) , 'JSP' ) from dual;


Output:
ONE HUNDRED FIFTY-EIGHT