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,
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