Home » RDBMS Server » Server Administration » Yahoo does it....
Yahoo does it.... [message #372907] Fri, 16 March 2001 14:51 Go to next message
John Daniel
Messages: 1
Registered: March 2001
Junior Member
Can you do a query to find a range of rows in the resultset (like a yahoo web search result), I tried this but it doesn't work....

Select * from aniadm.si_log
where ani ='8004824082'
and rownum > 10
and rownum < 10
order by out_date desc;

What I am wanting is a range of rows from the result set.

Report message to a moderator

Re: Yahoo does it.... [message #372908 is a reply to message #372907] Fri, 16 March 2001 15:21 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
See http://www.jlcomp.demon.co.uk/plsql_a.html
for some ideas.

You can of course consider doing the full query to Oracle and caching the results in your app and let it do the paging. Many considerations though, e.g when to un-cache, the nbeed to re-query anyway if there are updates, inserts or deletes by the user...

Report message to a moderator

Previous Topic: Re: Query response time
Next Topic: Raise_Application_ Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 01 16:43:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.