Skip to Main Content
Forums

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!

Currency conversion

3501915Jul 11 2017 — edited Jul 11 2017

Hi

I am currently working on Oracle 11.2.0.3. I have a table and its having (million records) columns with multiple currencies. Now would like to write Oracle pl/sql program, which will convert all country currencies and their values to  USD.

Here is the current output.

[/body]

sn.    currency          value

----------------------------------

1       USD               2000000

2       CAD               20000

3       INR                 98767.898

4       SGR               9008.09

5       EUR

6       <NZ>              9999999

7       <FR>

.....

..... other countries....

[/body]

Thanks

Suresh

Expected Output

-----------------------

sn.    currency          value

----------------------------------

1       USD               2000000

2       USD               <convert CAD to USD 20000 >

3       USD               98767.898

4       USD               9008.09

5       USD              

6       <USD>              9999999

7       <USD>

.....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2017
Added on Jul 11 2017
#forms, #moved-from-devops
3 comments
395 views