SQLPLUS – pause the sql results

SQL> set pause     on
SQL> set pagesize  30
SQL> set pause     'More: '
SQL> set linesize  120
SQL> SELECT * FROM TAB;
More:

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
ACCESS$                        TABLE
ALERT_QT                       TABLE
ALL_ALL_TABLES                 VIEW
ALL_APPLY                      VIEW
ALL_APPLY_CHANGE_HANDLERS      VIEW
ALL_APPLY_CONFLICT_COLUMNS     VIEW
ALL_APPLY_DML_CONF_COLUMNS     VIEW
ALL_APPLY_DML_CONF_HANDLERS    VIEW
ALL_APPLY_DML_HANDLERS         VIEW
ALL_APPLY_ENQUEUE              VIEW
ALL_APPLY_ERROR                VIEW
ALL_APPLY_ERROR_MESSAGES       VIEW
ALL_APPLY_EXECUTE              VIEW
ALL_APPLY_HANDLE_COLLISIONS    VIEW
ALL_APPLY_INSTANTIATED_GLOBAL  VIEW
ALL_APPLY_INSTANTIATED_OBJECTS VIEW
ALL_APPLY_INSTANTIATED_SCHEMAS VIEW
ALL_APPLY_KEY_COLUMNS          VIEW
ALL_APPLY_PARAMETERS           VIEW
ALL_APPLY_PROGRESS             VIEW
ALL_APPLY_REPERROR_HANDLERS    VIEW
ALL_APPLY_SPILL_TXN            VIEW
ALL_APPLY_TABLE_COLUMNS        VIEW
ALL_ARGUMENTS                  VIEW
ALL_ASSEMBLIES                 VIEW
ALL_ASSOCIATIONS               VIEW
ALL_ATTRIBUTE_TRANSFORMATIONS  VIEW
More:



TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
ALL_PART_INDEXES               VIEW
ALL_PART_KEY_COLUMNS           VIEW
ALL_PART_LOBS                  VIEW
ALL_PART_TABLES                VIEW
ALL_PENDING_CONV_TABLES        VIEW
ALL_PLSQL_OBJECT_SETTINGS      VIEW
ALL_POLICIES                   VIEW
ALL_POLICY_CONTEXTS            VIEW
ALL_POLICY_GROUPS              VIEW
ALL_PROBE_OBJECTS              VIEW
ALL_PROCEDURES                 VIEW
ALL_PROPAGATION                VIEW
ALL_QUEUES                     VIEW
ALL_QUEUE_PUBLISHERS           VIEW
ALL_QUEUE_SCHEDULES            VIEW
ALL_QUEUE_SUBSCRIBERS          VIEW
ALL_QUEUE_TABLES               VIEW
ALL_REFRESH                    VIEW
ALL_REFRESH_CHILDREN           VIEW
ALL_REFRESH_DEPENDENCIES       VIEW
ALL_REFS                       VIEW
ALL_REGISTERED_MVIEWS          VIEW
ALL_REGISTERED_SNAPSHOTS       VIEW
ALL_REGISTRY_BANNERS           VIEW
ALL_REPAUDIT_ATTRIBUTE         VIEW
ALL_REPAUDIT_COLUMN            VIEW
ALL_REPCAT                     VIEW

http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12030.htm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.