Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » splitting query result
splitting query result [message #76299] Wed, 23 January 2002 20:03 Go to next message
Henning
Messages: 6
Registered: October 2001
Junior Member
Hi There,

I am developing a website where I have to query a Oracle database which contain about 3 million records. The number of records returned will normally be around 200 - 300. I want to display them on a web page with only 25 records each time. the users can then click Next to see the next 25 records. How would I best achive this.

Regards
Henning
Re: splitting query result [message #76300 is a reply to message #76299] Wed, 23 January 2002 21:57 Go to previous messageGo to next message
shastry
Messages: 3
Registered: January 2002
Junior Member
You can use cursors to fetch limited records with <CURSOR_NAME>%ROWCOUNT option

shastry
Re: splitting query result [message #76314 is a reply to message #76299] Tue, 05 February 2002 04:08 Go to previous message
henn
Messages: 1
Registered: February 2002
Junior Member
thankz
Previous Topic: Oracle 8i
Next Topic: Re: ORA24327: Oracle 8i and Weblogic Server
Goto Forum:
  


Current Time: Thu Mar 28 19:57:00 CDT 2024