Skip to Main Content

Oracle Forms

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 amount in words in Forms?

wyfwongDec 8 2007 — edited Dec 9 2007
I wish to read a database item called AMOUNT from a table and display as a non-database display item on a Form.

e.g. AMOUNT: 1456.50
will diplay
ONE THOUSAN FIFTY SIX DOLLARS AND FIFTY CENTS ONLY

Is there any built-in functions like ToWords() function builtin in Crystal Reports to convert a number into word?
Any hints are welcome.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2008
Added on Dec 8 2007
4 comments
832 views