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

1.	set pause 'message'
2.	set pause off
3.	pause Press ENTER to begin
4.	Set pause text and show environment

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

Related examples in the same category