RE: SQL statement to return a block of rows
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Aug 2004 14:25:31 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jacques Kilchoer
Sent: Friday, August 20, 2004 2:17 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
