SQL> set pagesize 10
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE
---------- ---------- ---------- ---------- -------- -
7369 SMITH CLERK 7902 80/12/17
7499 ALLEN SALESMAN 7698 81/02/20
7521 WARD SALESMAN 7698 81/02/22
7566 JONES MANAGER 7839 81/04/02
7654 MARTIN SALESMAN 7698 81/09/28
7698 BLAKE MANAGER 7839 81/05/01
7782 CLARK MANAGER 7839 81/06/09
EMPNO ENAME JOB MGR HIREDATE
---------- ---------- ---------- ---------- -------- -
7788 SCOTT ANALYST 7566 87/04/19
7839 KING PRESIDENT 81/11/17
7844 TURNER SALESMAN 7698 81/09/08
7876 ADAMS CLERK 7788 87/05/23
7900 JAMES CLERK 7698 81/12/03
7902 FORD ANALYST 7566 81/12/03
7934 MILLER CLERK 7782 82/01/23
14 개의 행이 선택되었습니다.
SQL> select rownum, object_name from all_objects
2 where rownum<20;
ROWNUM OBJECT_NAME
---------- ------------------------------
1 /1005bd30_LnkdConstant
2 /10076b23_OraCustomDatumClosur
3 /10297c91_SAXAttrList
4 /103a2e73_DefaultEditorKitEndP
5 /10501902_BasicFileChooserUINe
6 /105072e7_HttpSessionBindingEv
7 /106ba0a5_ArrayEnumeration
ROWNUM OBJECT_NAME
---------- ------------------------------
8 /106faabc_BasicTreeUIKeyHandle
9 /10744837_ObjectStreamClass2
10 /1079c94d_NumberConstantData
11 /10804ae7_Constants
12 /108343f6_MultiColorChooserUI
13 /10845320_TypeMapImpl
14 /10948dc3_PermissionImpl
ROWNUM OBJECT_NAME
---------- ------------------------------
15 /1095ce9b_MultiComboBoxUI
16 /109a284b_OracleXMLStaticQuery
17 /109cbb8e_SpanShapeRendererSim
18 /10a45bfe_ProfilePrinterErrors
19 /10a793fd_LocaleElements_iw
19 개의 행이 선택되었습니다.