oracle pl/sql之存储过程(procedure)
select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
7369 SMITH CLERK 7902 1980-12-17 12:00:00 5000 20
7499 SMITH SALESMAN 7698 1981-02-20 12:00:00 5000 300 30
7521 WARD SALESMAN 7698 1981-02-22 12:00:00 1437.5 500 30
7566 JONES MANAGER 7839 1981-04-02 12:00:00 8013.97 20
7654 MARTIN SALESMAN 7698 1981-09-28 12:00:00 1437.5 1400 30
7698 BLAKE MANAGER 7839 1981-05-01 12:00:00 3277.5 30
7782 CLARK MANAGER 7839 1981-06-09 12:00:00 3084.27 10
7788 SCOTT ANALYST 7566 1987-04-19 12:00:00 4163.1 20
7839 KING PRESIDENT 1981-11-17 12:00:00 6797.97 10
7844 TURNER SALESMAN 7698 1981-09-08 12:00:00 1725 0 30
页:
[1]