Check Bind Variable History

set linesize 200

set pagesize 200

col cdate format a30

col VALUE_STRING format a20

alter session set NLS_DATE_FORMAT='YYYY:MM:DD HH24:MI:SS';

SELECT d. snap_id, NAME,POSITION,DATATYPE_STRING,VALUE_STRING,LAST_CAPTURED

FROM DBA_HIST_SQLBIND d WHERE SQL_ID='&sqlid'

order by LAST_CAPTURED,SNAP_ID,NAME desc;

Output: