From Oracle FAQ
A bind variable is a place-holder variable in a SQL statement that must be replaced with a valid value (or address of a value) before the statement can successfully execute.
"DELETE FROM employees WHERE empno = :EMPNO_BIND_VAR"
At runtime the program will provide a value for :EMPNO_BIND_VAR before executing the statement.
Capturing bind variables
Starting from Oracle 10g, bind variables are periodically captured in the v$sql_bind_capture and dba_hist_sqlbind views (keep in mind a Diagnostics Pack license is required for accessing dba_hist_* views).
Bind variables are captured either when a query is hard parsed; or if the last capture was _cursor_bind_capture_interval seconds ago (default 900).
|Glossary of Terms|