with the pagesize command, you can set the size of each page to control the amount of data displayed on each page. Syntax format of the pagesize command
As follows:
Set pagesize n
Where the parameter n represents a positive integer for each page size, the maximum value can be 50000, the default value is 14, the page is not just the output data
Composition, 20 by sql*plus like is to the screen of all output results constitute, including the title and Blank lines.
For example, when querying data from the EMP
Sql> select * from EMP;
EMPNO ename JOB MGR hiredate SAL COMM
DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ----------
----------
7369 SMITH Clerk 7902 1 July-December-80 800
20
7499 ALLEN salesman 7698 20月-February-81 1600 300
30
7521 WARD salesman 7698 2 February-February-81 1250 500
30
7566 JONES MANAGER 7839 February-April-81 2975
20
7654 MARTIN salesman 7698 2 August-September-81 1250 1400
30
7698 BLAKE MANAGER 7839 January-May-81 2850
30
7782 CLARK MANAGER 7839 September-June-81 2450
10
7788 SCOTT ANALYST 7566 2 April-January-87 3000
20
7839 KING President 1 July-November-81 5000
10
7844 TURNER salesman 7698 August-September-81 1500 0
30
7876 ADAMS Clerk 7788 February-April-87 1100
20
EMPNO ename JOB MGR hiredate SAL COMM
DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ----------
----------
7900 JAMES Clerk 7698 March-December-81 1800
30
7902 FORD ANALYST 7566 March-December-81 3000
20
7934 MILLER Clerk 7782 2 March-January-82 1300
10
7935 Xiaoxue MANAGER 7839 January-March-98 5000 500
20
15 rows have been selected.
Sql>
The results of the above query appear twice
EMPNO ename JOB MGR hiredate SAL COMM
DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ----------
----------
The title.
If we use the pagesize command to change,
Sql> Set pagesize 100
Sql> select * from EMP;
EMPNO ename JOB MGR hiredate SAL COMM
DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ----------
----------
7369 SMITH Clerk 7902 1 July-December-80 800
20
7499 ALLEN salesman 7698 20月-February-81 1600 300
30
7521 WARD salesman 7698 2 February-February-81 1250 500
30
7566 JONES MANAGER 7839 February-April-81 2975
20
7654 MARTIN salesman 7698 2 August-September-81 1250 1400
30
7698 BLAKE MANAGER 7839 January-May-81 2850
30
7782 CLARK MANAGER 7839 September-June-81 2450
10
7788 SCOTT ANALYST 7566 2 April-January-87 3000
20
7839 KING President 1 July-November-81 5000
10
7844 TURNER salesman 7698 August-September-81 1500 0
30
7876 ADAMS Clerk 7788 February-April-87 1100
20
7900 JAMES Clerk 7698 March-December-81 1800
30
7902 FORD ANALYST 7566 March-December-81 3000
20
7934 MILLER Clerk 7782 2 March-January-82 1300
10
7935 Xiaoxue MANAGER 7839 January-March-98 5000 500
20
15 rows have been selected.
Sql>
The title of the result will not appear more than once. When the amount of data is large, we can help our feet to see the results clearly.
Oracle uses the pagesize command
