6 OPEN my_emp_cur FOR 'select * from emp where deptno=:dno' USING 10;
7 LOOP
8 FETCH my_emp_cur INTO my_emp_rec;
9 EXIT WHEN my_emp_cur%NOTFOUND;
10 dbms_output.put_line(my_emp_rec.ename||'''s salary is : '||my_emp_rec.sal);
11 END LOOP;
12* END;
13 /
CLARK's salary is : 4900
KING's salary is : 5000
MILLER's salary is : 1300
PL/SQL procedure successfully completed.
SQL> /
CLARK's salary is : 4900
KING's salary is : 5000
MILLER's salary is : 1300
PL/SQL procedure successfully completed.
SQL> select sql_text,executions,sql_id from v$sqlarea where sql_text like 'select * from emp where deptno=:dno%';
SQL_TEXT EXECUTIONS SQL_ID
--------------------------------------------- ---------- -------------
select * from emp where deptno=:dno