Incorporating "GOAL SEEK" of MS Excel in Oracle [message #82018] |
Thu, 10 April 2003 08:17 |
Farrukh
Messages: 15 Registered: February 2002 Location: Pakistan
|
Junior Member |
|
|
Hello,
Is there any such option/built-in function in Oracle that returns the same result as Microsoft Excel does in "Goal Seek".
This requirement arises in making a Repayment Schedule of a Loan System.
In worst case, can we insert the values from Microsoft Excel sheet into any Oracle database.
Can anyone help me out.
Farrukh
|
|
|
Re: Incorporating [message #82076 is a reply to message #82018] |
Fri, 18 April 2003 05:35 |
Sun
Messages: 92 Registered: August 2002
|
Member |
|
|
If u want to store the Excel sheet also u can store.
U can create an ole container item and proceed with that.
If u want to data alone also u can store.
Take the data alone and u can insert into database using sqlloader.
|
|
|