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