How to display currency amount in words in Oracle?

Asked By Martin Thompson 100 points N/A Posted on - 09/27/2012

Is there a system function that I could use that automatically converts currency to amount in words in Oracle? Any help is greatly appreciated!

Thanks.

• Status: Open
• Question Views: 898
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Sharon D Mickelson

Go To Solution

Answered By Mackt Salaop 5 points N/A #190508

How to display currency amount in words in Oracle?

Hello,

The code provided below will efficiently convert the currency into word formats and display with compressed style. It is used as a generator of record gathering.

It can show different types of currencies especially global currencies or traditional currencies. But several new currencies can be put in there if needed.

 Thanks.

About Mackt Salaop

Questions
3

Answers
99

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 09/27/2012
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By Sharon D Mickelson 10 points N/A #190509

How to display currency amount in words in Oracle?

Here is the pseudo code for your requirement:

1. Check if the provided input is less than 0, if so print error.
2. Create a function with a switch case statement for printing value one to ten, eleven to nineteen and from ten, twenty to ninety.
3. If the length of the input is two or more, and if the second digit from the left is one, print the value of the last two digits together.
4. Else print the values of each digit.
5. Similarly, use the above logic using length to figure out hundreds, thousands and millions. Use the functions created in step 2 to print the values.

Hope this helps!

 

About Sharon D Mickelson

Questions
13

Answers
102

Best Answers
38

• Vote Up 0 Vote Down

• Posted on - 04/23/2013
• Question Category: Oracle Database