Oracle SQL - Pause and pagesize

  1. HOME
  2. Oracle SQL
  3. SQL Plus
  4. Pause and pagesize

Introduction

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.