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

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

RE: SQL statement to return a block of rows

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 20 Aug 2004 14:25:31 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D60E9AE72A@EXCHMN3>


Fantastic! Thanks very much!

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

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jacques Kilchoer Sent: Friday, August 20, 2004 2:17 PM
To: oracle-l_at_freelists.org
Subject: RE: SQL statement to return a block of rows

Link that avoids wrapping:
http://tinyurl.com/4t9xe
-----Original Message-----

From: Jacques Kilchoer

Tom Kyte has this article:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::NO::F4950_P8_DISPLAYID,F49 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

-----------------------------------------------------------------
----------------------------------------------------------------
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:26:41 CDT

Original text of this message

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