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;

posted on 2018-11-28 16:01  HelonTian  阅读(1491)  评论(0编辑  收藏  举报