SQL> define emp_no=7369 SQL> var o_cur refcursor SQL> DECLARE 2 3 BEGIN 4 OPEN :o_cur FOR SELECT* FROM emp WHERE empno=&emp_no; 5 END; 6 / old 4: OPEN :o_cur FOR SELECT* FROM emp WHERE empno=&emp_no; new 4: OPEN :o_cur FOR SELECT* FROM emp WHERE empno=7369;PL/SQL procedure successfully completed.SQL> print o_cur EMPNO ENAME JOB MGR HIREDATE SAL COMM ---------- ---------- --------- ---------- -------------- ---------- ---------- DEPTNO ---------- 7369 SMITH CLERK 7902 17-12月-80 800 20 SQL>
SQL> define emp_no=7369 SQL> var deptno number SQL> print deptno DEPTNO ---------- SQL> DECLARE 2 3 BEGIN 4 SELECT deptno INTO :deptno FROM emp WHERE empno=&emp_no; 5 END; 6 / old 4: SELECT deptno INTO :deptno FROM emp WHERE empno=&emp_no; new 4: SELECT deptno INTO :deptno FROM emp WHERE empno=7369;PL/SQL procedure successfully completed.SQL> print deptno DEPTNO ---------- 20SQL>
2 where empno=&emp_num;
输入 emp_num 的值: 7369
原值 2: where empno=&emp_num
新值 2: where empno=7369 EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-12月-80 800 20
SQL> define emp_no=7369
SQL> var o_cur refcursor
SQL> DECLARE
2
3 BEGIN
4 OPEN :o_cur FOR SELECT* FROM emp WHERE empno=&emp_no;
5 END;
6 /
old 4: OPEN :o_cur FOR SELECT* FROM emp WHERE empno=&emp_no;
new 4: OPEN :o_cur FOR SELECT* FROM emp WHERE empno=7369;PL/SQL procedure successfully completed.SQL> print o_cur EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK 7902 17-12月-80 800
20
SQL>
SQL> var deptno number
SQL> print deptno DEPTNO
----------
SQL> DECLARE
2
3 BEGIN
4 SELECT deptno INTO :deptno FROM emp WHERE empno=&emp_no;
5 END;
6 /
old 4: SELECT deptno INTO :deptno FROM emp WHERE empno=&emp_no;
new 4: SELECT deptno INTO :deptno FROM emp WHERE empno=7369;PL/SQL procedure successfully completed.SQL> print deptno DEPTNO
----------
20SQL>