santanur
09-22-2003, 10:02 AM
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
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