| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL statement to return a block of rows
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.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |