Antw: RE: piece-wise return of records from table

From: Guido Konsolke <Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com>
Date: Thu, 24 Jul 2003 07:33:39 +0200
Message-Id: <25998.339301@fatcity.com>

It IS efficient. Just click the link
that Jacques provided. Performance measuring is discussed in the thread.

>>> VIVEK_SHARMA_at_infosys.com 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) ]

Query to retrieve just the first 10 of the thousand records
Then have a link called "Next" and "Previous" in the Web page .
When Link is clicked , for instance when the user click "Next" then show records from 11-20 ..

Qs. Will the following SQL Query be EFFICIENT for such retrievals w.r.t. Performance Load ?

Sorry for the incomplete details on front-end as I am located at a different GEO Location .

Thanks indeed for the responses .

-----Original Message-----
Sent: Wednesday, July 23, 2003 7:30 AM
To: VIVEK_SHARMA

HiVivek ,

Use this SQL query to achive your piece wise operation...

Select *
from ( Select a.*, rownum r

           from ( Select *
                    from tablename
                   where condition 
                   order by column list ) a
          where rownum < :HigerBound )

where r > :LowerBound
Let me know your output..

Thanks and Regards

-----Original Message-----
Sent: Tuesday, July 22, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L

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 ;-)

>>> VIVEK_SHARMA_at_infosys.com 22.07.2003 14.49 Uhr >>>
CASE select * from table gives 1000 records (say)

We want only first ten of these records to be returned to the front end

& then records 11 to 20 & so on ...

How may the above be optimally possible ?

SQL or PL/SQL any for it ?

Thanks

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Guido Konsolke
  INET: Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Thu Jul 24 2003 - 00:33:39 CDT