Multiple Rows per Fetch

Each fetch returns one row to the client in default behavior. The returned rows per fetch can be changed to another number by entering:

set cursor rows number for cursor_name

number specifies the number of rows per fetch the cursor can execute. This number can be a numeric literal with no decimal point, or a local variable of type integer. If cursor rows is greater than one, multiple rows return to the client after fetch. In some cases, the rows returned by fetch may be less than the number of rows specified, depending on the cursor’s position. The current cursor position is always one row.