Oracle教程 2023-02-23

Oracle 视图 ALL_OPBINDINGS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_OPBINDINGS是Oracle目录视图,其中包含有关Oracle调用表/视图和PL/SQL存储过程/函数/包的站点绑定信息。用户可以使用该视图来检索PL/SQL代码中特定变量的站点绑定信息。该视图比较有用,可以帮助查询分析师检查他们是否正确地设置变量绑定,这有助于提高性能。

使用ALL_OPBINDINGS视图进行具体步骤如下：

1. 使用SQL*Plus连接到Oracle数据库。

2. 执行以下查询：

select * from all_opbindings where bindvar_name=’bind_varname’

3. 结果显示绑定变量的详细信息：

BINDVAR_NAME 表示绑定的变量的名称。
OWNER 表示拥有该PL/SQL块的用户的名称。
PLSQL_UNIT_TYPE 表示PL/SQL单元的类型：TABLE / VIEW / PACKAGE / PROCEDURE / FUNCTION /TYPE。
PLSQL_UNIT_OWNER 表示PL/SQL对象的所有者。
PLSQL_UNIT_NAME 表示PL/SQL单元的名称。
POSITION 表示变量在PL/SQL单元内的位置。
DATA_TYPE 表示变量的数据类型。
DATA_LENGTH 表示变量的长度bin。
DATA_SCALE 表示变量的比例因子。

官方英文解释

ALL_OPBINDINGS describes the binding functions and methods on the operators accessible to the current user.

Related Views

DBA_OPBINDINGS describes the binding functions and methods on all operators in the database.
USER_OPBINDINGS describes the binding functions and methods on the operators owned by the current user.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the operator
`OPERATOR_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the operator
`BINDING#`	`NUMBER`	`NOT NULL`	Binding number of the operator
`FUNCTION_NAME`	`VARCHAR2(92)`		Name of the binding function or method as specified by the user
`RETURN_SCHEMA`	`VARCHAR2(128)`		Name of the schema of the return type if the return type of the binding is an object type
`RETURN_TYPE`	`VARCHAR2(128)`		Name of the return type
`IMPLEMENTATION_TYPE_SCHEMA`	`VARCHAR2(128)`		If the operator was created `WITH INDEX CONTEXT` or `SCAN CONTEXT`, then this column displays the schema of the implementation type used by the functional implementation of the operator as a scan context (null if the operator was created without this syntax). See Also: the `CREATE OPERATOR` statement in Oracle Database SQL Language Reference
`IMPLEMENTATION_TYPE`	`VARCHAR2(128)`		If the operator was created `WITH INDEX CONTEXT` or `SCAN CONTEXT`, then this column displays the name of the implementation type used by the functional implementation of the operator as a scan context (null if the operator was created without this syntax). See Also: the `CREATE OPERATOR` statement in Oracle Database SQL Language Reference
`PROPERTY`	`VARCHAR2(43)`		Property of the operator binding: `WITH INDEX CONTEXT` `COMPUTE ANCILLARY DATA` `ANCILLARY TO` `WITH COLUMN CONTEXT` `WITH INDEX, COLUMN CONTEXT` `COMPUTE ANCILLARY DATA, WITH COLUMN CONTEXT`

本站中文解释

官方英文解释

相关推荐