ORACLE 根据 sql_id 查询绑定变量的传入值

查询当前查询：

select b.NAME,
b.POSITION,
b.DATATYPE_STRING,
b.VALUE_STRING,
b.LAST_CAPTURED
from v$sql_bind_capture b
where b.sql_id = 'XXXXXX';

查询历史查询：

select b.name, b.datatype_string, b.value_string, b.last_captured
from dba_hist_sqlbind b
where b.sql_id = 'XXXXXX'
order by 4;

转载于:https://www.cnblogs.com/ShaYeBlog/p/10599041.html