Oracle PL/SQL Tutorial/SQL PLUS Session Environment/Skip — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
|
Текущая версия на 13:04, 26 мая 2010
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>