RE: piece-wise return of records from table

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Thu, 24 Jul 2003 09:03:24 +0530
Message-Id: <25998.339298@fatcity.com>

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-----
From: P.Kamalanathan [mailto:kamal.p_at_serialsys.com.sg] Sent: Wednesday, July 23, 2003 7:30 AM
To: VIVEK_SHARMA
Subject: Re: piece-wise return of records from table

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-----
From: Guido Konsolke [mailto:Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com] Sent: Tuesday, July 22, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L Subject: RE: piece-wise return of records from table

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

Received on Wed Jul 23 2003 - 22:33:24 CDT