My Experiments with Oracle

By Sriram Sanka -The AUAA

Spell number In Indian Currency System Using Function (Number into words)

Posted by sriram 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 🙂

Advertisements

7 Responses to “Spell number In Indian Currency System Using Function (Number into words)”

  1. 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

  2. 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.

  3. 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.

  4. www said

    www

    Spell number In Indian Currency System Using Function (Number into words) «

  5. 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.

  6. RobertPeax said

    appropriate time to make some plans for the future and it’s

  7. 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: