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/elontian/p/10032648.html