René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

set pagesize [SQL*Plus]

set pagesize n
Sets the heigth of a page to n. If n=0, the page's heigth is considered infinite.
If SQL*Plus is used interactively, this command can be used to make the output more readable.

Storing settings across sessions

Settings (such as pagesize) can be stored accross sessions with the glogin.sql and/or login.sql file.