Selecting a range of records

Hello everybody!

        I want to make a select of a table with a great amount of records and I only want to select only a range of them, for example, records between number 32 and 112.

        Is it posible to include a range in a select query in Oracle? I've heard that it's possible in Informix, I think.

        What I want to do with it is decrease the traffic between Oracle and a JSP application we have in different servers.         

        Thanks.

                Abel S. Received on Thu Jul 05 2001 - 03:59:58 CDT