Oracle PL/SQL Tutorial/SQL PLUS Session Environment/pause

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. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/setpauseon.htm">set pause on</a> 29. 10. 3. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/setpausemessage.htm">set pause "message"</a> 29. 10. 4. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/setpauseoff.htm">set pause off</a> 29. 10. 5. <A href="/Tutorial/Oracle/0580__SQL-PLUS-Session-Environment/setpauseoffpagesize42.htm">set pause off pagesize 42</a>

set pause "message"

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

set pause off

SQL> show pages
pagesize 22
SQL> show pause
SQL> set pause off
SQL> show pause
SQL>
SQL>

set pause off pagesize 42

SQL>
SQL> create table employees(
  2    empno      NUMBER(4)
  3  , ename      VARCHAR2(8)
  4  , init       VARCHAR2(5)
  5  , job        VARCHAR2(8)
  6  , mgr        NUMBER(4)
  7  , bdate      DATE
  8  , msal       NUMBER(6,2)
  9  , comm       NUMBER(6,2)
 10  , deptno     NUMBER(2) ) ;
Table created.
SQL>
SQL>
SQL> insert into employees values(1,"Jason",  "N",  "TRAINER", 2,   date "1965-12-18",  800 , NULL,  10);
1 row created.
SQL> insert into employees values(2,"Jerry",  "J",  "SALESREP",3,   date "1966-11-19",  1600, 300,   10);
1 row created.
SQL> insert into employees values(3,"Jord",   "T" , "SALESREP",4,   date "1967-10-21",  1700, 500,   20);
1 row created.
SQL> insert into employees values(4,"Mary",   "J",  "MANAGER", 5,   date "1968-09-22",  1800, NULL,  20);
1 row created.
SQL> insert into employees values(5,"Joe",    "P",  "SALESREP",6,   date "1969-08-23",  1900, 1400,  30);
1 row created.
SQL> insert into employees values(6,"Black",  "R",  "MANAGER", 7,   date "1970-07-24",  2000, NULL,  30);
1 row created.
SQL> insert into employees values(7,"Red",    "A",  "MANAGER", 8,   date "1971-06-25",  2100, NULL,  40);
1 row created.
SQL> insert into employees values(8,"White",  "S",  "TRAINER", 9,   date "1972-05-26",  2200, NULL,  40);
1 row created.
SQL> insert into employees values(9,"Yellow", "C",  "DIRECTOR",10,  date "1973-04-27",  2300, NULL,  20);
1 row created.
SQL> insert into employees values(10,"Pink",  "J",  "SALESREP",null,date "1974-03-28",  2400, 0,     30);
1 row created.
SQL>
SQL>
SQL> show pagesize
pagesize 22
SQL> show pause
PAUSE is OFF
SQL> set  pause "[Enter]... "
SQL> set  pause on
SQL> set  pagesize 10
SQL>
SQL> select * from employees;
[Enter]...
 EMPNO      last_name       INIT  JOB         MGR BDATE        MSAL DEPTNO
------ -------------------- ----- -------- ------ ---------- ------ ------
     1 Jason                N     TRAINER       2 18-12-1965    800     10
     2 Jerry                J     SALESREP      3 19-11-1966   1600     10
     3 Jord                 T     SALESREP      4 21-10-1967   1700     20
     4 Mary                 J     MANAGER       5 22-09-1968   1800     20
     5 Joe                  P     SALESREP      6 23-08-1969   1900     30
     6 Black                R     MANAGER       7 24-07-1970   2000     30
     7 Red                  A     MANAGER       8 25-06-1971   2100     40
[Enter]... set pause off pagesize 42
 EMPNO      last_name       INIT  JOB         MGR BDATE        MSAL DEPTNO
------ -------------------- ----- -------- ------ ---------- ------ ------
     8 White                S     TRAINER       9 26-05-1972   2200     40
     9 Yellow               C     DIRECTOR     10 27-04-1973   2300     20
    10 Pink                 J     SALESREP null   28-03-1974   2400     30
10 rows selected.
SQL> SP2-0734: unknown command beginning "t pause of..." - rest of line ignored.
SQL> show all
appinfo is OFF and set to "SQL*Plus"
arraysize 15
autocommit OFF
autoprint OFF
autorecovery OFF
autotrace OFF
blockterminator "." (hex 2e)
btitle OFF and is the following 66 characters:
col 20 "Confidential" tab 8                "Created by: " SQL.USER
cmdsep OFF
colsep " "
compatibility version NATIVE
concat "." (hex 2e)
copycommit 0
COPYTYPECHECK is ON
define "&" (hex 26)
describe DEPTH 1 LINENUM OFF INDENT ON
echo ON
editfile "afiedt.buf"
embedded OFF
escape OFF
FEEDBACK ON for 1 or more rows
flagger OFF
flush ON
heading ON
headsep "|" (hex 7c)
instance "local"
linesize 80
lno 9
loboffset 1
logsource ""
long 999
longchunksize 80
markup HTML OFF HEAD "<title>HTML Demo Report</title>                <link rel="stylesheet" href="format.css">" BODY "" TABLE "border="1" width="90%" align="center" summary="Script output"" SPOOL ON ENTMAP ON PREFORMAT OFF
newpage 1
null "null"
numformat "99999"
numwidth 6
pagesize 10
PAUSE is ON and set to "[Enter]... "
pno 2
recsep WRAP
recsepchar " " (hex 20)
release 1002000100
repfooter OFF and is NULL
repheader OFF and is NULL
serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED
shiftinout INVISIBLE
showmode OFF
spool OFF
sqlblanklines OFF
sqlcase MIXED
sqlcode 0
sqlcontinue "> "
sqlnumber ON
sqlpluscompatibility 10.2.0
sqlprefix "#" (hex 23)
sqlprompt "SQL> "
sqlterminator ";" (hex 3b)
suffix "sql"
tab ON
termout ON
timing OFF
trimout ON
trimspool ON
ttitle OFF and is the following 194 characters:
left        "SQL*Plus report"                  right       "Page: " format 99 SQL.PNO         skip center "OVERVIEW"                         skip center "employees department 30"          skip 2
underline "-" (hex 2d)
USER is "sqle"
verify OFF
wrap : lines will be wrapped
SQL>
SQL> drop table employees;
Table dropped.
SQL>
SQL> set pause off

set pause on

SQL> set pause " "
SQL> set pause on
SQL> run

SQL>