set linesize 300
set serveroutput on
set ver off

column name format a15
column pos format 999
column value_string format a40
column Value_Date format a35
column datatype_string format a20


alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss';

begin
dbms_output.put_line('Parametros de la consulta &1 en cache');
end;
/


select h.last_captured, h.was_captured, h.name,h.position pos,h.datatype_string,h.value_string,anydata.AccessTimestamp(value_anydata) Value_Date
from v$sql_bind_capture h
where h.sql_id = '&1'
order by h.CHILD_ADDRESS desc, h.position;

UNDEFINE 1
UNDEFINE 2
UNDEFINE 3

CLEAR BUFFER
