select a range of cells

how can i select a range of complex cells... i know i probably have to use pl/sql to do this... any of the means i have used in straight sql... such as

select id from mytable where status=1 and rowid in ( select rowid from mytable where rownum <=8 minus
select rrowid from mytable where rownum < 2) order by ts desc;

are flawed in that they dont allow much more complexity... like multiple tables.

my main goal is to write something that does pagination of many results for a webpage.... obviosuly i dont want to get all the results and show a faction everytime.

thanks Received on Sat Dec 09 2000 - 22:50:32 CST