Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: returning rows between two positions in a large query

Re: Q: returning rows between two positions in a large query

From: Roman Starek <starek_at_pluto.spsselib.hiedu.cz>
Date: 22 Jun 1999 08:04:39 GMT
Message-ID: <7kng2n$7ac$1@adis.cesnet.cz> 






The simpliest way is to fetch first 50 records and then show
records to user.



In some cases is posible to use hint INDEX_ASC, INDEX_DESC and there
you may ask pseudocolumn rownum ( do not use this pseudocolumn in other cases ).




If you want to know more ask on my email



                        Starous
Received on Tue Jun 22 1999 - 03:04:39 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US