Control Number of Records returned?

Is there anyway at the Server level to control the number of records Oracle returns without using a cursor?

For example, if I submit the following SQL statement in a client application...And "foo" has 50,000 records...

   select a, b, c
   from foo;

Can I request the Oracle server to return 50 records at a time without coding this at the application level?

Appreciate any comments on this,

Wayne Denison
Harris Corp in "Sunny Florida"
wdenison_at_harris.com Received on Fri Apr 21 1995 - 00:00:00 CEST