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.

Note	The maximum number for the page size is 50,000.