Check Bind Variables
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;