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: How to select only the first 20 rows in a SQL statement

Re: How to select only the first 20 rows in a SQL statement

From: Michele Viviani <viviani_at_infostud.dsi.unifi.it>
Date: Wed, 13 Oct 1999 18:03:46 +0200
Message-ID: <7u2agm$f9u$1@pluto.sm.dsi.unimi.it> 





>


>Can anyone help ?


>


>I need to issue an SQL statement (either select, delete or update) that


>I want to perform only on the first  20 rows returned and then


>subsequently repeat the statement on the next 20 rows and so on and so


>forth


>




Can you use PL/SQL and cursor.


Can You ?



Michele Viviani


Received on Wed Oct 13 1999 - 11:03:46 CDT












Original text of this message













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