Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> displaying n number of records
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 Mon Feb 11 2002 - 16:17:18 CST