pagesize_demo.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 25 行

 set pagesize 8;
   select * from emp;

 EMPNO ENAME      JOB              MGR HIREDATE          SAL       COMM     DEPTNO
------ ---------- --------- ---------- ---------- ---------- ---------- ----------
  7369 SMITH      CLERK           7902 17-12月-80        800                    20
  7499 ALLEN      SALESMAN        7698 20-2月 -81       1600        300         30
  7521 WARD       SALESMAN        7698 22-2月 -81       1250        500         30
  7566 JONES      MANAGER         7839 02-4月 -81       2975                    20
  7654 MARTIN     SALESMAN        7698 28-9月 -81       1250       1400         30

 EMPNO ENAME      JOB              MGR HIREDATE          SAL       COMM     DEPTNO
------ ---------- --------- ---------- ---------- ---------- ---------- ----------
  7698 BLAKE      MANAGER         7839 01-5月 -81       2850                    30
  7782 CLARK      MANAGER         7839 09-6月 -81       2450                    10
  7788 SCOTT      ANALYST         7566 19-4月 -87       3000                    20
  7839 KING       PRESIDENT            17-11月-81       5000                    10
  7844 TURNER     SALESMAN        7698 08-9月 -81       1500          0         30

 EMPNO ENAME      JOB              MGR HIREDATE          SAL       COMM     DEPTNO
------ ---------- --------- ---------- ---------- ---------- ---------- ----------
  7876 ADAMS      CLERK           7788 23-5月 -87       1100                    20
  7900 JAMES      CLERK           7698 03-12月-81        950                    30
  7902 FORD       ANALYST         7566 03-12月-81       3000                    20
  7934 MILLER     CLERK           7782 23-1月 -82       1300                    10