Chapter 3: Reference Topics for Oracle

set rowcount

The command set rowcount value limits the number of rows returned in a result set. The default is to return all rows.