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

Home -> Community -> Usenet -> c.d.o.misc -> How to duplicate set fetchrows?

How to duplicate set fetchrows?

From: Ken Sproule <kenmn_at_tds.net>
Date: Wed, 05 Apr 2000 12:44:13 GMT
Message-ID: <p9dmes8507etbcr1b33jrbfpisdi8j7idn@4ax.com> 





Thanks for your help.



I used to use "set fetchrows 200" to limit the number of rows returned
in SQL*Worksheet, but it doesn't seem to work in 8.1.6.



Anyone have any insight into how to accomplish the same thing.



Rownums won't work because they get rearranged durring sorts.



Best,



Ken Sproule


kenmn_at_tds.net




Ken Sproule


kenmn_at_tds.net
Received on Wed Apr 05 2000 - 07:44:13 CDT












Original text of this message













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