Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Mortgage calculations in Oracle
- Thread starter mike777
- Start date
SantaMufasa
Technical User
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.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
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)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
- Thread starter
- #3
SantaMufasa
Technical User
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)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
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)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
- Thread starter
- #5
KenCunningham
Technical User
Never mind princ_payment(), int_payment() etc, is there a function for rip_off()? ;-)
SantaMufasa
Technical User
Yes, Ken, that function occurs when you pay for your Oracle license. <grin> ![[wink]](/data/assets/smilies/wink.gif "[wink] [wink]")
Mufasa
(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
Mufasa(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
- Status
Similar threads
- Locked
- Question