http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSQL_Plus%2FSkip
Oracle PL/SQL/SQL Plus/Skip - История изменений
2026-05-23T22:15:40Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/SQL_Plus/Skip&diff=1705&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/SQL_Plus/Skip&diff=1706&oldid=prev
Admin: 1 версия
2010-05-26T09:58:42Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Skip page==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create table emp<br />
2 ( empno NUMBER(4) constraint E_PK primary key<br />
3 , ename VARCHAR2(8)<br />
4 , init VARCHAR2(5)<br />
5 , job VARCHAR2(8)<br />
6 , mgr NUMBER(4)<br />
7 , bdate DATE<br />
8 , sal NUMBER(6,2)<br />
9 , comm NUMBER(6,2)<br />
10 , deptno NUMBER(2) default 10<br />
11 ) ;<br />
<br />
SQL><br />
SQL> break on deptno skip page -<br />
> on job skip 1<br />
SQL><br />
SQL> select deptno, job, empno, ename, sal, comm<br />
2 from emp<br />
3 order by deptno, job;<br />
Enter...<br />
DEPTNO JOB EMPNO ENAME SAL COMM<br />
------ -------- ------ -------- ------ ------<br />
10 Designer 7 Chris 2450 [N/A]<br />
9 Peter 5000 [N/A]<br />
Manager 14 Mike 1300 [N/A]<br />
Enter... break<br />
DEPTNO JOB EMPNO ENAME SAL COMM<br />
------ -------- ------ -------- ------ ------<br />
20 Designer 4 Jane 2975 [N/A]<br />
TRAINER 8 Smart 3000 [N/A]<br />
11 Ana 1100 [N/A]<br />
13 Fake 3000 [N/A]<br />
1 Tom 800 [N/A]<br />
Enter...<br />
DEPTNO JOB EMPNO ENAME SAL COMM<br />
------ -------- ------ -------- ------ ------<br />
30 Designer 6 Black 2850 [N/A]<br />
Manager 12 Jane 800 [N/A]<br />
Tester 10 Take 1500 0<br />
2 Jack 1600 300<br />
3 Wil 1250 500<br />
5 Mary 1250 1400<br />
<br />
14 rows selected.<br />
SQL> SP2-0042: unknown command "k" - rest of line ignored.<br />
SQL><br />
SQL><br />
SQL> drop table emp;<br />
Table dropped.<br />
<br />
<br />
<br />
<br />
</source></div>
Admin