dev

• Sep 12th, 2006

 

This will work upto 1 million:

Try this:

SQL> select to_char(to_date(1234567,'j'),'jsp') from dual;

TO_CHAR(TO_DATE(1234567,'J'),'JSP')
---------------------------------------------------------------------
one million two hundred thirty-four thousand five hundred sixty-seven

Radhi09

 Profile Answers by Radhi09 

• Feb 15th, 2007

 

HI Dev,Its working but can u explain it more clearly thanks,Radhi

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 22nd, 2008

 

SELECT TO_CHAR(TO_DATE(11111,'J'),'JSP')||' DOLLARS' FROM DUAL

This will work for the  values in  between 1 and 5373484 only.