Thursday, April 15, 2010

Display numeric value in words using SQL

SQL> select to_char(to_date(123,'J',),'JSP') from dual;

output as below

ONE HUNDRED TWENTY-THREE