set pagesize 10 : Page Size « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. Page Size

SQL> set pagesize 10
SQL>
SQL> select rownum, object_name from all_objects where rownum < 20;


    ROWNUM OBJECT_NAME
---------- ------------------------------
         1 ICOL$
         2 I_USER1
         3 CON$
         4 UNDO$
         5 C_COBJ#
         6 I_OBJ#
         7 PROXY_ROLE_DATA$


    ROWNUM OBJECT_NAME
---------- ------------------------------
         8 I_IND1
         9 I_CDEF2
        10 I_PROXY_ROLE_DATA$_1
        11 FILE$
        12 UET$
        13 I_FILE#_BLOCK#
        14 I_FILE1
 --

    ROWNUM OBJECT_NAME
---------- ------------------------------
        15 I_CON1
        16 I_OBJ3
        17 I_TS#
        18 I_CDEF4
        19 IND$

19 rows selected.