Scenario = To display a search result for all the employees in a org.
[ Normally the query will retrieve 1000 records (say) ]
1) Query to retrieve just the first 10 of the thousand records
2) Then have a link called Next and Previous in the Web page .
3) When Link is clicked , for instance
It IS efficient. Just click the link
that Jacques provided. Performance measuring
is discussed in the thread.
[EMAIL PROTECTED] 24.07.2003 06.34 Uhr
Scenario = To display a search result for all the employees in a org.
[ Normally the query will retrieve 1000 records (say) ]
1) Query to
Hi,
any chance that you let us know what your front end is?
Web? CS-Forms? fill_in_the_appropriate?
Come on, some more infos. Typing isn't that hard ;-)
[EMAIL PROTECTED] 22.07.2003 14.49 Uhr
CASE
select * from table gives 1000 records (say)
We want only first ten of these records
Tom Kyte to the rescue!
getting rows N through M of a result set
http://asktom.oracle.com/pls/ask/f?p=4950:8:::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:127412348064,
or
http://tinyurl.com/hqsl
(You can ignore the little argument on that page where Mr. Kyte lays down the law
about not using
I guess it wouldn't hurt to include Mr. Kyte's answer:
select *
from ( select a.*, rownum rnum
from ( YOUR_QUERY_GOES_HERE -- including the order by ) a
where rownum = MAX_ROWS )
where rnum = MIN_ROWS
/
He demonstrates on the site why this is the best solution.