I was reading the article here:
I am working from an oracle 8i database with a few thousand records in it.
Can you help me out here? I tried the example method, and it appears to me that it is only returning sets of data
that are below the ROWNUM I request. For example, if I use .... WHERE ROWNUM<100 ... It looks like it only gets data from the first 100 rows of the table instead of a count of the query's result row numbers.
When I put a very loose term into the search, it should return the max, 100 lines, but only returns 87. I know one query produces 156 results, but this limit cuts off at 60.
I really would like to be able to show 30 results per page and have users click 'next page' to view the next 30. It seems absurd to me that with Postgress, or MySQL I can do this very easily with ... LIMIT 100,30 .... but the expensive Oracle DB does not have the capability? I don't know.
Please, if you know you can help. (PLEASE!)
Not optimal, but should work:
(select tb.*, rownum rn
from TABLE_NAME tb
where isql.rn between BEGIN_ROW and END_ROW;
Search for WINDOW ROWNUM in this forum - lots of exampes of how to use ROWNUM for windowing properly
Click Here to Expand Forum to Full Width