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>