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.