Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

function to get the interest rate

840954Feb 18 2011 — edited Feb 21 2011
hi;
iam trying to develop a function to return te rate of a loan knowing the original ammount, monthly payment, term.

basically what i need is the same as rate function in excel but i cant find the matematical function to calculate the rate

thanks

orestes

Comments

Chaitanya.S.S.K
you can use the dblinks in ur pl/sql cursor queries.

for ur reference:

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_56a.htm#SQLRF01205

and to use them for some advance concepts like authentication or replication, please search the documentation.
519688
well, since all pl/sql does is to pass the SQL statement to the database to be run, it's not a pl/sql issue. it's a SQL question. so it's the same as running the query in sqlplus (or toad or frog or whatever you use). the fact that it's embedded in pl/sql doesn't change anything, so: yes, it's possible, and no there aren't any do/don'ts (other than what would already apply to native SQL.
547947
Thnks Guys... :-)
585425
In My application encountering "ORA-01001: invalid cursor" error while calling the stored procedures using db link.

Can you please help me
585236
Verifies that these the procedure to which flames are compiled, that you have access permissions, that exist dblink, and that you are executing it with the permissions of the proprietor user of procedure.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 21 2011
Added on Feb 18 2011
4 comments
6,118 views