SET PAGESIZE 60
SET LINESIZE 300

COLUMN sql_text FORMAT A120
COLUMN sql_id FORMAT A13
COLUMN bind_name FORMAT A10
COLUMN bind_value FORMAT A26

SELECT 
  sql_id,
  t.sql_text sql_text,  
  b.name bind_name,
  b.value_string bind_value 
FROM
  DBA_HIST_SQLTEXT t 
JOIN
  DBA_HIST_SQLBIND b  using (sql_id)
WHERE
  b.value_string is not null  
AND
  sql_id='&sqlid';