Information générale
Titre:
Limit # rows returned by Oracle using SQL passthrough
Is it possible to limit the number of rows that are returned (say 300) from a select statement using SQL passthrough to an Oracle database.
IF so, is it possible to then retrieve the next 300 rows.
Currently, I am doing a count of the number of rows that would be returned from the query. If the number is greater than 300 I display a message box giving the user the option of retrieveing the data or allowing them to narrow the scope of their query.
Any help would be greatly appreciated.
Greg
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement