Retrieve results in different pages

From: David Yuen <dyuen1_at_netvigator.com>
Date: Sat, 26 Dec 1998 14:15:42 +0800
Message-ID: <7633ba$561$1_at_imsp009a.netvigator.com>



Hi,

I am working on some WEB Based stuff with Oracle 7.3.3.

Since the result set is too large, so I want to break it into a few different pages. is there anyway to retrieve records in that way?

for example
--Page 1-

1
2
3
4
5

-Page 2-

6
7
8
9
10

However, WEB is stateless, and so need to call SQL statement twice. The stuff part is to exactly retrieve the result from the result set's record number 6

Regards,
David Received on Sat Dec 26 1998 - 07:15:42 CET

Original text of this message