查看绑定变量的值

1.声明绑定变量

SQL> var v_name varchar2(10)

 

2.给变量赋值

SQL> exec :v_name:='KING'

PL/SQL 过程已成功完成。

3.必须使用绑定的变量的值，才能在 v$sql_bind_capture看到其值。否则是为空的

SQL> select sal from emp where ename=:v_name;

       SAL
----------
      5000

 

4.下面就是查看绑定变量的值

简单的：

SQL> edi
已写入 file afiedt.buf

  1* SELECT value_string FROM v$sql_bind_capture where name=':V_NAME'
SQL> /

VALUE_STRING
------------------------------------------------------------------------------

 

KING

 

详细的：

SQL> SELECT hash_value,sql_id,NAME,POSITION,DATATYPE_STRING,LAST_CAPTURED,value_
string FROM v$sql_bind_capture where name=':V_NAME';

HASH_VALUE SQL_ID
---------- -------------
NAME                                                           POSITION
------------------------------------------------------------ ----------
DATATYPE_STRING                LAST_CAPTURED
------------------------------ --------------
VALUE_STRING
--------------------------------------------------------------------------------

3442101771 b2wb7wr6knmhb
:V_NAME                                                               1
VARCHAR2(32)

 

HASH_VALUE SQL_ID
---------- -------------
NAME                                                           POSITION
------------------------------------------------------------ ----------
DATATYPE_STRING                LAST_CAPTURED
------------------------------ --------------
VALUE_STRING
--------------------------------------------------------------------------------

2144396763 czxrsupzx1tfv
:V_NAME                                                               1
VARCHAR2(32)

 

HASH_VALUE SQL_ID
---------- -------------
NAME                                                           POSITION
------------------------------------------------------------ ----------
DATATYPE_STRING                LAST_CAPTURED
------------------------------ --------------
VALUE_STRING
--------------------------------------------------------------------------------

4054008838 4yzm5m3su6j06
:V_NAME                                                               1
VARCHAR2(32)                   05-8月 -10
KING