Home » Developer & Programmer » Forms » Incorporating "GOAL SEEK" of MS Excel in Oracle
Incorporating "GOAL SEEK" of MS Excel in Oracle [message #82018] Thu, 10 April 2003 08:17 Go to next message
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 Go to previous message
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.
Previous Topic: How do i use connect in forms
Next Topic: Has anyone converted 6i web forms or reports to 9i?
Goto Forum:
  


Current Time: Wed Jun 26 12:51:16 CDT 2024