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

Материал из SQL эксперт
Перейти к: навигация, поиск

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>