Oracle教程 2023-02-23

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

本站中文解释

ALL_IDENTIFIERS视图显示了有关Python对象的标识符的摘要和信息。它允许您查询代码里使用的关键字、变量和标识符的详细信息，以及其它代码块中定义的对象。ALL_IDENTIFIERS视图用于帮助编程者正确使用变量、函数等，它包括以下列：

1. IDENTIFIER：指定标识符的名称
2. MAPPED_NAME：此标识符在模块里声明的名称
3. TYPE：指定标识符的种类，如变量、函数、函数参数或者类属性等
4. BLOCK_ID：指明标识符定义在哪种代码块中
5. LINE_NUM：该标识符的定义所在的行号

使用Oracle的ALL_IDENTIFIERS视图的过程如下：

1. 首先，应该使用Python函数inspect获取要查询的模块信息，包括函数声明、变量定义等。

2. 然后，可以使用Oracle视图ALL_IDENTIFIERS去查询定义在不同代码块里的标识符的详细信息，可以同时使用多个过滤条件。

3. 最后，根据需要获得的信息，可以使用SQL查询语句，根据查询的结果获取视图中相关的结果数据。

官方英文解释

ALL_IDENTIFIERS displays information about the identifiers in the stored objects accessible to the current user.

Related Views

DBA_IDENTIFIERS displays information about the identifiers in all stored objects in the database.
USER_IDENTIFIERS displays information about the identifiers in the stored objects owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the identifier
`NAME`	`VARCHAR2(128)`		Name of the identifier
`SIGNATURE`	`VARCHAR2(32)`		Signature of the identifier
`TYPE`	`VARCHAR2(18)`		Type of the identifier. For SQL identifiers, the types include: `TABLE` `VIEW` `SEQUENCE` `ALIAS` `COLUMN` `MATERIALIZED VIEW` `OPERATOR` For PL/SQL identifiers, the types include: `FUNCTION` `PROCEDURE` `PACKAGE`
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object where the identifier action occurred
`OBJECT_TYPE`	`VARCHAR2(13)`		Type of the object where the identifier action occurred
`USAGE`	`VARCHAR2(11)`		Type of the identifier usage: `DECLARATION` `DEFINITION` `CALL` `REFERENCE` `ASSIGNMENT`
`USAGE_ID`	`NUMBER`		Unique key for the identifier usage within the object
`LINE`	`NUMBER`		Line number of the identifier action
`COL`	`NUMBER`		Column number of the identifier action
`USAGE_CONTEXT_ID`	`NUMBER`		Context `USAGE_ID` of the identifier usage
`CHARACTER_SET`	`VARCHAR2(10)`		Contains the value of the `character set` clause when it is used in a variable identifier declaration. These are the possible values when the character set is derived from another variable identifier: `CHAR_CS` `NCHAR_CS` `IDENTIFIER`
`ATTRIBUTE`	`VARCHAR2(7)`		Column contains the attribute value when `%attribute` is used in a variable declaration. Possible values: `ROWTYPE` `TYPE` `CHARSET`
`CHAR_USED`	`VARCHAR2(4)`		Contains the type of the length constraint when it is used in a string length constraint declaration. Possible values: `CHAR` `BYTE`
`LENGTH`	`NUMBER`		Contains the numeric length constraint value for a string length constraint declaration
`PRECISION`	`NUMBER`		Contains the numeric precision when it is used in a variable declaration
`PRECISION2`	`NUMBER`		Contains the numeric second precision value (for instance, interval types) used in a variable declaration
`SCALE`	`NUMBER`		Contains the numeric scale value used in a variable declaration.
`LOWER_RANGE`	`NUMBER`		Contains the numeric lower range value used by a variable declaration with a range constraint
`UPPER_RANGE`	`NUMBER`		Contains the numeric upper range value used by a variable declaration with a range constraint
`NULL_CONSTRAINT`	`VARCHAR2(8)`		This column is set when a `NULL` constraint is used by a variable declaration. Possible values: `NULL` `NOT NULL`
`SQL_BUILTIN`	`VARCHAR2(3)`		Is set to `YES` when an identifier is a SQL builtin used in a SQL statement issued from PL/SQL. Otherwise, this column is set to `NO`.
`IMPLICIT`	`VARCHAR2(3)`		Indicates whether the identifier is an implicit identifier that does not appear in the source (`YES`) or not (`NO`)
`DECLARED_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object in which this identifier was declared
`DECLARED_OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object in which this identifier was declared
`DECLARED_OBJECT_TYPE`	`VARCHAR2(12)`		Type of the object in which this identifier was declared
`ORIGIN_CON_ID`	`VARCHAR2(256)`		The ID of the container where the data originates. Possible values include: `0`: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)

本站中文解释

官方英文解释

相关推荐