Thanks for the tip, Andre. I settled though with the
handy ROWNUM pseudo-column and subquery.
select f1 from (select f1, ROWNUM as row_index from
<table> order by f1 asc) where row_index>=$offset AND
row_index<=$end_range;
Thanks for all the tips.
mary christie.
>> * in oracle, how do i set a limit which rows to
>> return from a select, like from the fifth row to
>> the Nth skipping the others
> for this you DECLARE a CURSOR to do the SELECT
> statement you want. Then you can use the FOR
> <number> FETCH statement to limit returned number
> of rows in your query.
>
> -Andre
>
__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
