Solved

IRR function in PL/SQL

Posted on 2003-12-03
3
3,086 Views
Last Modified: 2007-12-19
On Oracle 8i,

Does anyone know where can I find pl/sql function that does Internal revenue return (IRR)?
I know I can find it in Oracle financials but my client does not want to purchace this package.
If someone has a source he is willing to share...that might help a lot.

Thanks
0
Comment
Question by:peledc
  • 3
3 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 450 total points
ID: 9872841
Some financial functions such as IRR, NPV are part of the embedded OLAP services in Oracle 9i Enterprise Edition
If you create an Analytical Workspace you will have the ability to use these functions via the OLAP DML.

For more information please see the Oracle OLAP User's Guide and the Oracle OLAP DML guide.

0
 
LVL 48

Expert Comment

by:schwertner
ID: 9872897
Seems that they mean Internal Rate of Return function what is not what you want.
Simply go to IRS and ask them how to calculate the function. They will give you a booklet.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 9872952
Post your question also here

http://www.oaug.org/






0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Row_number in SQL 6 45
Read XML values 8 58
Fill Date time Field 12 33
How to get the current date and Time upon oracle insert into a database table 9 61
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question