------------- ---------- ------------ -------------------------------------------------------
dbc6vx6z6n1zv 3194619899 0 select ename,job,sal from emp where empno=:eno
SQL> exec :eno:=7369;
SQL> select ename,job,sal from emp where empno=:eno; -->再次对变量赋值并查询
ENAME JOB SAL
---------- --------- ----------
SMITH CLERK 800
SQL> exec :eno:=7521
SQL> select ename,job,sal from emp where empno=:eno;
ENAME JOB SAL
---------- --------- ----------
WARD SALESMAN 1250
SQL> select sql_id,sql_text,executions from v$sqlarea -->视图v$sqlarea中EXECUTIONS值为3，对应的SQL被执行了3次
2 where sql_text like '%select ename,job,sal%' and sql_text not like '%from v$sql%';
SQL_ID SQL_TEXT EXECUTIONS
------------- ------------------------------------------------------- ----------
dbc6vx6z6n1zv select ename,job,sal from emp where empno=:eno 3
-->视图v$sql中对应的子游标也实现了完全共享，保持CHILD_NUMBER为0