My Experiences with Databases & More

Oracle-MySQL-SQL SERVER-Python-Azure-AWS-Oracle Cloud-GCP etc

  • Enter your email address to follow this blog and receive notifications of new posts by email.

  • Total Views

    • 558,488 hits
  • $riram $anka

    The experiences, Test cases, views, and opinions etc expressed in this website are my own and does not reflect the views or opinions of my employer. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content.Product and company names mentioned in this website may be the trademarks of their respective owners.

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;


1 row selected.

ind> select to_char(to_date(‘259′,’J’),’JSP’) from dual;


1 row selected.

ind> select to_char(to_date(‘9999′,’J’),’JSP’) from dual;


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;

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;

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 🙂


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


    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: Logo

You are commenting using your 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: