set pagesize : Page Size « Report Column Page « Oracle PL / SQL

1. Oracle PL / SQL
2. Report Column Page
3. Page Size

set pagesize

SQL> set pagesize 10
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.

SQL>
SQL>

           
       

Related examples in the same category