Check Bind Variables

From NazimWIKI
Jump to navigation Jump to search

Here's a way you can check on what bind variable values have been parsed in a query.

SELECT a.sql_id
     , a.sql_text
     , b.name
     , b.value_string
  FROM v$sql a
     , v$sql_bind_capture b
 WHERE a.sql_id = b.sql_id
   AND a.sql_id= &SQLID;