RE: SQL statement to return a block of rows

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 20 Aug 2004 12:12:28 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F879E9@irvmbxw02>

Tom Kyte has this article:
http://asktom.oracle.com/pls/ask/f?p=3D4950:8:::NO::F4950_P8_DISPLAYID,F4= 9
50_P8_CRITERIA:127412348064,
getting rows N through M of a result set

-----Original Message-----

DENNIS WILLIAMS List - In a SQL statement with an ORDER clause, can I provide a starting and
end point (or offset) based on rows returned? Oracle9i

We are converting a small application from SQL Server to Oracle (good!). In
SQL Server they do everything with stored procedures, but in Oracle we plan
to just use SQL statements. In SQL Server one stored procedure retrieves a
screenfull of rows and returns them, so the cursor is managed on the database side. I said that for Oracle we would probably want to do this similarly with just SQL statements. This works except for the screenful business. I said we could wrap the query in a PL/SQL shell and use a cursor,
but the team is thinking there must be a way. If someone has a PL/SQL template, please send it to me. One of them uses MySql and says this feature
is available there.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Fri Aug 20 2004 - 14:08:19 CDT