Re: Control Number of Records returned?
From: E A Macnaghten <ar02_at_dial.pipex.com>
Date: 1995/04/23
Message-ID: <3nc77k$572_at_vent.pipex.net>#1/1
> Is there anyway at the Server level to control the number of records Oracle
> returns without using a cursor?
>
Date: 1995/04/23
Message-ID: <3nc77k$572_at_vent.pipex.net>#1/1
wdenison_at_ic1d.harris.com (Wayne Denison) wrote:
>
> Is there anyway at the Server level to control the number of records Oracle
> returns without using a cursor?
>
The ROWNUM field could be used for this:
select a, b, c from foo where rownum <= 50
or
select a, b, c from foo where rownum between 51 and 100
Caveat: - The rownum field ignores any "order by" clauses, so I don't know if this will help you.
Best of luck
Yours ever
Eddy Received on Sun Apr 23 1995 - 00:00:00 CEST