Mortgage calculations in Oracle

[mike777]

Hello all.
Is there any way to do mortgage calculations in Oracle? Like Principal payment, Interest payment, APR, etc?
Thank you.
-Mike Kemp

 

[SantaMufasa]

Mike,

Sure, you can do all of these calculations in Oracle (or Sybase, or DB2, or SQL Server, or MySQL, et cetera). Such calculations are not typically built-in functions, but rather, result from user-defined code.

If you can identify the formulae/algorithms for what you want, then you/someone can build the code to produce the result you want.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[mike777]

Thanks, Dave.
I guess I should have been more specific.
I was really looking for some built-in functions!!
If anyone knows anything about this, it would be appreciated.
Thanks!!
-Mike

 

[SantaMufasa]

Mike,

That's precisely my point...Oracle does not have a family of functions named, Princ_payment(), or Int_payment, or APR(), but if you provide the algorithm of how you want such functions to behave, then you and I can build the code for user-defined functions that would act just like the built-in functions that you were hoping for.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[mike777]

Thanks...will do.
Let me see, I may have found a work around for now.
Thanks again.
-Mike

 

[KenCunningham]

Never mind princ_payment(), int_payment() etc, is there a function for rip_off()? ;-)

 

[SantaMufasa]

Yes, Ken, that function occurs when you pay for your Oracle license. <grin>

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.