Spell number In Indian Currency System Using Function (Number into words)
Posted by Sriram Sanka on May 20, 2011
As we all know We can convert number into words Using ‘Jsp’ format string in to_char function.
ind> select to_char(to_date(‘250′,’J’),’JSP’) from dual;
TO_CHAR(TO_DATE(‘
—————–
TWO HUNDRED FIFTY
1 row selected.
ind> select to_char(to_date(‘259′,’J’),’JSP’) from dual;
TO_CHAR(TO_DATE(‘259’,
———————-
TWO HUNDRED FIFTY-NINE
1 row selected.
ind> select to_char(to_date(‘9999′,’J’),’JSP’) from dual;
TO_CHAR(TO_DATE(‘9999′,’J’),’JSP’)
————————————–
NINE THOUSAND NINE HUNDRED NINETY-NINE
1 row selected.
But It has some limitations….See
ind> select to_char(to_date(‘250.25′,’J’),’JSP’) from dual;
select to_char(to_date(‘250.25′,’J’),’JSP’) from dual
*
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
ind> select to_char(to_date(‘9999999999.99′,’J’),’JSP’) from dual;
select to_char(to_date(‘9999999999.99′,’J’),’JSP’) from dual
*
ERROR at line 1:
ORA-01854: julian date must be between 1 and 5373484
We can avoid this By creating one Function .
This is similar to Ask Tom Spell number
ind> select spell_number(‘9999999999.99’) from dual;
SPELL_NUMBER(‘9999999999.99’)
——————————————————————————–
nine billion nine hundred ninety-nine million nine hundred ninety-nine thousand
nine hundred ninety-nine
1 row selected.
ind> select into_rupees(‘9999999999.99’) from dual;
INTO_RUPEES(‘9999999999.99’)
——————————————————————————–
Nine Arab Ninety-Nine Crore Ninety-Nine Lakh Ninety-Nine Thousand Nine Hundred N
inety-Nine and Paise Ninety-Nine.
You can find this into_rupees script at Indian Rupees
Thank you 🙂
My Experiences with Databases & More 
superfluous said
That is very interesting, You are a very professional blogger.
I’ve joined your rss feed and look ahead to in quest of more of your excellent post.
Additionally, I’ve shared your web site in my social networks
LikeLike
immediate said
whoah this blog is great i love reading your articles.
Stay up the good work! You already know, lots of people are searching round for this
information, you could aid them greatly.
LikeLike
MLSP said
For the greatest can be a result of social networking, develop
links that tie them altogether. Add links for your blog where
guests can comply with yourself on Twitter, come across
your videos on the web, and as should you on Facebook.
Within your Twitter profile, range from the URL for the weblog and Facebook.
LikeLike
www said
www
Spell number In Indian Currency System Using Function (Number into words) «
LikeLike
cuartos juveniles said
After going over a number of the blog articles
on your web page, I seriouslyy appreciate your technique of writing
a blog. I bookmarked it to my bookmark webpage lkst and will be checking ack soon. Please check out myy web site as well andd let me know yoour opinion.
LikeLike
RobertPeax said
appropriate time to make some plans for the future and it’s
LikeLike
Mathilde said
Great post. I was checking constantly this blog and I
am impressed! Extremely helpful information particularly the last part 🙂
I care for such information a lot. I was seeking this certain info for a very long time.
Thank you and good luck.
LikeLike