Skip page
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.
Related examples in the same category