Oracle Database 10g SQL (Osborne ORACLE Press Series)

Setting the Page Size

You set the number of lines in a page using the SET PAGESIZE command. This command sets the number of lines that SQL*Plus considers one page of output, after which SQL*Plus will display the headings again.

Set the page size to 100 lines using the following SET PAGESIZE command and run your query again using / :

SQL> SET PAGESIZE 100 SQL> / PRODUCT_ID PRODUCT_NAME DESCRIPTION PRICE ---------- ------------- ------------- -------- 1 Modern A description .95 Science of modern science 2 Chemistry Introduction .00 to Chemistry 3 Supernova A star .99 explodes 4 Tank War Action movie .95 about a future war 5 Z Files Series on .99 mysterious activities

Notice the headings are only shown once at the top, and the resulting output looks better.