Answer by KillerDBA ·
If you're using SQL*Plus, there's a
set pagesize <n>
command you can use.
However, if I wanted to look at something formatted nicely for reading by page, I think I'd just go ahead and create an Access report. Access isn't quite ubiquitous but it's very common and the report mechanism is easy to use. Alternatively, you could run a query in Excel to populate a formatted page. We do that often.