top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: How to display the number value in Words ?

+2 votes
494 views
Oracle: How to display the number value in Words ?
posted Mar 16, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
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

Explanation:
First convert desire number to julien type using to_date function..and then convert o/p into char type using to_char function..

answer Mar 17, 2015 by Santosh Kumar Panigrahi
...