在命令行模式下,sqlplus下如何设置表头隔多久出现一次呢???SQL> / EMPNO ENAME SAL DEPTNO DEPTNO LOC
---------- ---------- ---------- ---------- ---------- -------------
7782 CLARK 2450 10 10 NEW YORK
7839 KING 5000 10 10 NEW YORK
7934 MILLER 1300 10 10 NEW YORK
7566 JONES 2975 20 20 DALLAS
7902 FORD 3000 20 20 DALLAS
7876 ADAMS 1100 20 20 DALLAS
7369 SMITH 800 20 20 DALLAS
7788 SCOTT 3000 20 20 DALLAS
7521 WARD 1250 30 30 CHICAGO
7844 TURNER 1500 30 30 CHICAGO
7499 ALLEN 1600 30 30 CHICAGO EMPNO ENAME SAL DEPTNO DEPTNO LOC
---------- ---------- ---------- ---------- ---------- -------------
7900 JAMES 950 30 30 CHICAGO
7698 BLAKE 2850 30 30 CHICAGO
7654 MARTIN 1250 30 30 CHICAGO
40 BOSTON已选择15行。比如结果是这样的。
---------- ---------- ---------- ---------- ---------- -------------
7782 CLARK 2450 10 10 NEW YORK
7839 KING 5000 10 10 NEW YORK
7934 MILLER 1300 10 10 NEW YORK
7566 JONES 2975 20 20 DALLAS
7902 FORD 3000 20 20 DALLAS
7876 ADAMS 1100 20 20 DALLAS
7369 SMITH 800 20 20 DALLAS
7788 SCOTT 3000 20 20 DALLAS
7521 WARD 1250 30 30 CHICAGO
7844 TURNER 1500 30 30 CHICAGO
7499 ALLEN 1600 30 30 CHICAGO EMPNO ENAME SAL DEPTNO DEPTNO LOC
---------- ---------- ---------- ---------- ---------- -------------
7900 JAMES 950 30 30 CHICAGO
7698 BLAKE 2850 30 30 CHICAGO
7654 MARTIN 1250 30 30 CHICAGO
40 BOSTON已选择15行。比如结果是这样的。
-- 正解: pagesize n
-- n表示一页存在的数据记录行数!