Oracle PL/SQL Tutorial/SQL PLUS Session Environment/Skip

Skip page

   <source lang="sql">

SQL> SQL> create table emp

 2  ( empno      NUMBER(4)    constraint E_PK primary key
 3  , ename      VARCHAR2(8)
 4  , init       VARCHAR2(5)
 5  , job        VARCHAR2(8)
 6  , mgr        NUMBER(4)
 7  , bdate      DATE
 8  , sal        NUMBER(6,2)
 9  , comm       NUMBER(6,2)
10  , deptno     NUMBER(2)    default 10
11  ) ;

SQL> SQL> break on deptno skip page - > on job skip 1 SQL> SQL> select deptno, job, empno, ename, sal, comm

 2  from   emp
 3  order  by deptno, job;

Enter... DEPTNO JOB EMPNO ENAME SAL COMM

---

-------- ------ -------- ------ ------

   10 Designer      7 Chris      2450  [N/A]
                    9 Peter      5000  [N/A]
      Manager      14 Mike       1300  [N/A]

Enter... break DEPTNO JOB EMPNO ENAME SAL COMM

---

-------- ------ -------- ------ ------

   20 Designer      4 Jane       2975  [N/A]
      TRAINER       8 Smart      3000  [N/A]
                   11 Ana        1100  [N/A]
                   13 Fake       3000  [N/A]
                    1 Tom         800  [N/A]

Enter... DEPTNO JOB EMPNO ENAME SAL COMM

---

-------- ------ -------- ------ ------

   30 Designer      6 Black      2850  [N/A]
      Manager      12 Jane        800  [N/A]
      Tester       10 Take       1500      0
                    2 Jack       1600    300
                    3 Wil        1250    500
                    5 Mary       1250   1400

14 rows selected. SQL> SP2-0042: unknown command "k" - rest of line ignored. SQL> SQL> SQL> drop table emp; Table dropped.</source>