Oracle SQL - Pause and pagesize


The following code demonstrates using the SET command to change some SQL*Plus settings.

SQL> set pagesize 22
SQL> set pause "Hit [Enter]... "
SQL> set pause on

SQL> run
  1* select * from courses

Hit [Enter]...

PAUSE and PAGESIZE settings makes SQL*Plus to produce screen output per page.

The PAUSE setting is useful if the results of your SQL commands don't fit on your screen.

When using the PAUSE setting, specify a prompt string, too. Otherwise, SQL*Plus will just wait until you press the enter key.