9.49 V$SQL_BIND_METADATA
V$SQL_BIND_METADATA
describes metadata related to bind variables.
V$SQL_BIND_METADATA
describes, for each distinct bind variable in each cursor owned by the session querying this view:
-
Bind metadata provided by the client, if the bind variable is user defined
-
Metadata based on the underlying literal, if the
CURSOR_SHARING
parameter is set toFORCE
and the bind variable is system-generated.
Column | Datatype | Description |
---|---|---|
|
|
Memory address of the child cursor that owns this bind variable |
|
|
Bind position |
|
|
Internal identifier for the bind data type. Beginning in Oracle Database 12c, a number representing a PL/SQL data type can appear in this column. |
|
|
Maximum length of the bind value |
|
|
Maximum number of array elements (for array binds only) |
|
|
User-defined or system-generated bind variable name (if used) |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: