set linesize 300
set serveroutput on
set ver off

column name format a15
column position format 999
column value_string format a50
column Value_Date format a30


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

begin
dbms_output.put_line('Parametros de la consulta &3 en la instancia &1 para el Snap_id &2');
end;
/


select h.last_captured,h.name,h.position pos,h.datatype_string,h.value_string as value_string,anydata.AccessTimestamp(value_anydata) Value_Date from dba_hist_sqlbind h
where h.instance_number = &1 and h.snap_id = &2 and h.sql_id = '&3';

UNDEFINE 1
UNDEFINE 2
UNDEFINE 3

CLEAR BUFFER
