PAUSE : pause « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. pause

Using the following statement will tell SQL*Plus to stop spooling output to the screen after each page.

set pause on

To turn pause off, use the following command:

set pause off

29.10.pause
29.10.1.PAUSE
29.10.2.set pause on
29.10.3.set pause 'message'
29.10.4.set pause off
29.10.5.set pause off pagesize 42