Re: Info needed on cursor control

In article <32513AAA.41C6_at_rz.ruhr-uni-bochum.de>,

   Jens Hohmann <hohmajbt_at_rz.ruhr-uni-bochum.de> wrote:
>to increase the performance of our Oracle based applications, we are
>looking for a cursor control via SQL net, thus realising a kind of data
>control.

to avoid returning the result over the network, change the query to a create table as select ... statement. add another column to this temporary table containing the rownum of the result. index the temp table on this rownum column. now query the temp table on just the rownums you desire. you cannot directly manipulate the cursor forward/backward/randomly as you described it.

 create table temp_X as select rownum row_X,col1,col2,... from X where ...;  create unique index temp_X on temp_X(row_X);

note that you must alias the rownum because it is a reserved word.

Dave Mausner, Managing Consultant, Braun Technology Group, Chicago. Received on Tue Oct 01 1996 - 00:00:00 CEST