how to use the pause command to slow down the output displayed on your terminal : pause « SQL Plus « Oracle PL / SQL

1. Oracle PL / SQL
2. SQL Plus
3. pause

how to use the pause command to slow down the output displayed on your terminal

    
SQL>
SQL> --:
SQL>
SQL> show pause
PAUSE is OFF
SQL> set pause on
SQL> show pause
PAUSE is ON and set to ""
SQL> select username,profile from dba_users where rownum < 50;
USERNAME
------------------------------
PROFILE
------------------------------
JAVA2S
DEFAULT

SYS
DEFAULT

SYSTEM
DEFAULT

ANONYMOUS
DEFAULT

MDSYS
DEFAULT

OUTLN
DEFAULT

DIP
DEFAULT

TSMSYS
DEFAULT

FLOWS_FILES
DEFAULT

CTXSYS
DEFAULT

DBSNMP
DEFAULT

FLOWS_020100
DEFAULT

XDB
DEFAULT

HR
DEFAULT


14 rows selected.

SQL> --

   
    
    
  

Related examples in the same category