asktom.oracle.com has a number of articles on this problem.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"humble_one" <rastapoppolous_at_yahoo.com> wrote in message
news:42bb2f93.0202111417.60cfe005_at_posting.google.com...
> Hi there,
> I have a table that contains records > 10000, and my user wants to
> view them 1000 at a time sorted by a particular column.
> The coulmns of the table are non-numeric
> fetching the results in a scrollable result set and displaying seems
> to be too time consuming as there are a lot of records.
> What is an efficient approach to solve this problem ?
> any pointers to how to use them effectively would be helpful.
> the table is on an oracle database and the gui / connection to the db
> is through java / jdbc.
> an approach that seems to be rather time consuming and inefficient
> which i tried and gave up was the following:
> create view view1 as select col1 from tab1 order by col1;
> create view view2 as select rownum as rownumber , col1, from view1;
> and then querying view1.
> Thanks,
> Karthik
Received on Tue Feb 12 2002 - 06:05:17 CST
