SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- ---------- ---------- -------- ---------- ---------- ----------
7369 SMITH CLERK 7902 80/12/17 800 20
7499 ALLEN SALESMAN 7698 81/02/20 1600 300 30
7521 WARD SALESMAN 7698 81/02/22 1250 500 30
7566 JONES MANAGER 7839 81/04/02 2975 20
7654 MARTIN SALESMAN 7698 81/09/28 1250 1400 30
7698 BLAKE MANAGER 7839 81/05/01 2850 30
7782 CLARK MANAGER 7839 81/06/09 2450 10
7788 SCOTT ANALYST 7566 87/04/19 3000 20
7839 KING PRESIDENT 81/11/17 5000 10
7844 TURNER SALESMAN 7698 81/09/08 1500 0 30
7876 ADAMS CLERK 7788 87/05/23 1100 20
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- ---------- ---------- -------- ---------- ---------- ----------
7900 JAMES CLERK 7698 81/12/03 950 30
7902 FORD ANALYST 7566 81/12/03 3000 20
7934 MILLER CLERK 7782 82/01/23 1300 10
14 개의 행이 선택되었습니다.
SQL> col sal format $9,999.99;
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- ---------- ---------- -------- ---------- ---------- ----------
7369 SMITH CLERK 7902 80/12/17 $800.00 20
7499 ALLEN SALESMAN 7698 81/02/20 $1,600.00 300 30
7521 WARD SALESMAN 7698 81/02/22 $1,250.00 500 30
7566 JONES MANAGER 7839 81/04/02 $2,975.00 20
7654 MARTIN SALESMAN 7698 81/09/28 $1,250.00 1400 30
7698 BLAKE MANAGER 7839 81/05/01 $2,850.00 30
7782 CLARK MANAGER 7839 81/06/09 $2,450.00 10
7788 SCOTT ANALYST 7566 87/04/19 $3,000.00 20
7839 KING PRESIDENT 81/11/17 $5,000.00 10
7844 TURNER SALESMAN 7698 81/09/08 $1,500.00 0 30
7876 ADAMS CLERK 7788 87/05/23 $1,100.00 20
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- ---------- ---------- -------- ---------- ---------- ----------
7900 JAMES CLERK 7698 81/12/03 $950.00 30
7902 FORD ANALYST 7566 81/12/03 $3,000.00 20
7934 MILLER CLERK 7782 82/01/23 $1,300.00 10
14 개의 행이 선택되었습니다.