My Experiments With Oracle


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;


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 )

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


Oracle DBA's Daily Work

Welcome everyone!! The idea of this blog is to help the DBA in their daily tasks. Enjoy.

Anand's Blog

My experiences and views on Oracle Database

Tanel Poder's blog: Core IT for geeks and pros

Oracle Performance Tuning, Troubleshooting, Internals

Yet Another OCM

Journey as an Oracle Certified Master

Sharing Knowledge is ultimate key to Gaining knowledge...

Neil Chandler's DB Blog

A resource for Database Professionals

DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

OraExpert Academy

Consulting and Training


The Ramblings and Ravings Of Author Jason A. Rust

So Many Oracle Manuals, So Little Time

“Books to the ceiling, Books to the sky, My pile of books is a mile high. How I love them! How I need them! I'll have a long beard by the time I read them”—Lobel, Arnold. Whiskers and Rhymes. William Morrow & Co, 1988.


Oracle databases, storage and the high-performance world of flash memory


The thoughts of Jason Arneil

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting


Dominic Brooks on Oracle Performance, Tuning, Data Quality & Sensible Design ... (Now with added Sets Appeal)

Martins Blog

Trying to explain complex things in simple terms

Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Talip Hakan Ozturk's ORACLE BLOG

The secret of success is at your fingertips!...

Martin Widlake's Yet Another Oracle Blog

Oracle performance, Oracle statistics and VLDBs

Richard Foote's Oracle Blog

Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music

Oracle Scratchpad

Just another Oracle weblog

Oracle DBA Blog

Procedures, learnings and fixes encountered by a Junior DBA

Oracle ACE Director Kai Yu's Oracle Blog

Share Oracle Tips and Tricks and Related News



Online Identity & Access Management

One Stop Shop for Identity & Access Management

Babu B


Uwe Hesse

about Database Technology

Oracle database internals by Riyaj

Discussions about Oracle performance tuning, RAC, Oracle internal & E-business suite. is the best place for your personal blog or business site.

Kamran Agayev's Oracle Blog

Oracle Certified Master

%d bloggers like this: