Suggest Solution to the Senario...Urgent

[santanur]

I have a situation. There is an Oracle 8i Database that has millions of records. I need to formulate a solution for the following:-

1. Extract a dataset into files that are visible on web. The query would return minimum of 2 million records, even after including the filter conditions forced by the user. Users wants the data in excel sheets as they are going to manupulate the records using excel formulas. Any other environment such as excel is also accepted where the can perform certain calculations based on the extracted DataSet. Its not possible to show the records in excel as it has a max capacity of 65536.

2. Can I use Oracle Discoverer 4i ...but how to save it in Excel as the data set is so huge.

3. Will XML or Java technology help in any ways.

Please suggest a solution that you all feel would be feasible.

Regards
Shan

[Srinivas_Sharma]

Hi,

One of the solution might be to put it as xml files and provide a link to the xml file.

HTH
Srini

[santanur]

But can I edit the XML files on the web. By editing I mean that can I apply certain formulas on them on adhoc basis.

Can there be something which a bit simple.

Regards