RE: SQL statement to return a block of rows
- From: "Bill Tantzen" <tantz001@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Aug 2004 15:06:24 -0500
Hi Dennis!
Here is a snip of pl/sql code that has worked for me. If I am
understanding you question correctly, this may be what you need.
SELECT ordval, token, offset
FROM (
SELECT rownum AS ordval, token, offset
FROM finding_aid_token
WHERE query_id = 5424
ORDER BY offset
)
WHERE ordval < 20;
I hope all is good with you and your family! It always pleases me to
see your name pop up in my inbox -- which it does a number of times
everyday it seems!
Take care,
Bill
Bill Tantzen
University of Minnesota Libraries
tantz001@xxxxxxxxxx
612-626-9949 (office) 612-250-6125 (cell)
________________________________________________________________
I guess the man's a genius, but what
a dirty mind he has, hasn't he? -- Nora Joyce
--> -----Original Message-----
--> From: oracle-l-bounce@xxxxxxxxxxxxx
--> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DENNIS WILLIAMS
--> Sent: Friday, August 20, 2004 2:26 PM
--> To: 'oracle-l@xxxxxxxxxxxxx'
--> Subject: 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@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_D
--> ISPLAYID,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
--> -----------------------------------------------------------------
-->
----------------------------------------------------------------
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:
