SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert Number to Words using SQL?

518258Mar 16 2007 — edited Mar 16 2007

Hello All,

I have to convert some number into its word representation

e.g. if number = 1234 then I want to convert it into
'one thousand two hundred thirty four Rs.'

so how it is done using SQL? I think it uses to_char function with format as 'jsp' but I m nt getting exactly wat to do?

can anybody help?

regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2007

Added on Mar 16 2007

4 comments

595 views