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 calculate loan APR rate using pl/sql ?

carl0021May 7 2008 — edited May 9 2008

Hi all,
I was wondering if anyone knows how to use pl/sql to calculate APR's

Basically, I need to write a procedure that takes a given APR rate, Period of payment (months not years) and then works out the monthly payments......

Any half code will do that at least shows the formular to work out APR's in Oracle, then I can extend it to do anything else that i need

cheers

css_jay99

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2008

Added on May 7 2008

6 comments

2,662 views