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

Home -> Community -> Mailing Lists -> Oracle-L -> SQL statement to return a block of rows

SQL statement to return a block of rows

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 20 Aug 2004 13:57:34 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D60E9AE728@EXCHMN3>


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.

Dennis Williams
DBA
Lifetouch, Inc.

"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive."
-- C.S. Lewis



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 - 13:58:31 CDT

Original text of this message

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