Re: Displaying Oracle resultset in pages

Thanks Jan, it works great!

cheers,
Erik

Jan Korecki <Jan.Korecki_at_contactor.se> wrote in message news:<3fb8dc1e$0$97842$57c3e1d3_at_news3.bahnhof.se>...
> Hello!
>
> Check out asktom:
>
> http://asktom.oracle.com/pls/ask/f?p=4950:8:1280765191206413595::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:127412348064,
>
>
> example:
>
> SELECT *
> FROM ( SELECT a.*, ROWNUM rnum
> FROM ( SELECT * FROM hr.employees ORDER BY employee_id DESC ) a
> WHERE ROWNUM <= &MAX_ROWS )
> WHERE rnum >= &MIN_ROWS
>
>
>
> to get the first 25 records: MIN_ROWS=1 , MAX_ROWS=25
> the next 25: MIN_ROWS=26, MAX_ROWS=50
> ...
>
> The query performance will degrade when min_rows get high but that is
> usually not a problem because people usually dont check the records on
> "page 10" in google.
>
>
>
> Regards,
> Janne!
>
> Erik wrote:
>
> > Hi,
> >
> > I'd like to perform a search on an Oracle database and then display
> > the resulting records over different pages, much like the way
> > Google-searchresults appear. Can anybody tell me how the SQL would
> > look like?
> >
> > Thanks,
> > Erik
Received on Tue Nov 18 2003 - 03:42:58 CST