Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

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 ------------------------------ RNTSOFT 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> --