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"
<source lang="sql">
SQL> SQL> SQL> set pagesize 22 SQL> set pause "Hit [Enter]... " SQL> set pause on SQL> run SQL> SQL> SQL></source>
set pause off
<source lang="sql">
SQL> show pages pagesize 22 SQL> show pause SQL> set pause off SQL> show pause SQL> SQL></source>
set pause off pagesize 42
<source lang="sql">
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</source>
set pause on
<source lang="sql">
SQL> set pause " " SQL> set pause on SQL> run
SQL></source>