Oracle教程 2023-03-21

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

本站中文解释

ALL_ATTRIBUTE_DIM_LVL_CLS_AE 表示维度视图与属性视图的联合，将维度和属性的层级，类别，Attribute，Level的信息融为一体，可以清晰的看到一个属性属于某一维度，且是维度的哪个级别，同时还有这个属性的类别和属性所代表的信息。

使用方法：
1. 首先需要打开Oracle的SQL Developer软件；
2. 打开SQL Developer之后，需要根据情况选择正确的连接数据库；
3. 直接输入ALL_ATTRIBUTE_DIM_LVL_CLS_AE的表名，按下回车；
4. 系统会返回ALL_ATTRIBUTE_DIM_LVL_CLS_AE里面的信息，如果想查询特定的问题，可以相应的在表中使用查询语句进行查询。

官方英文解释

ALL_ATTRIBUTE_DIM_LVL_CLS_AE describes the level classifications of the attribute dimensions (across all editions) accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_LVL_CLS_AE describes the level classifications of all attribute dimensions (across all editions) in the database.
USER_ATTRIBUTE_DIM_LVL_CLS_AE describes the level classifications of the attribute dimensions (across all editions) 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 attribute dimension
`DIMENSION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the attribute dimension
`LEVEL_NAME`	`VARCHAR2(128)`		Name of the level
`CLASSIFICATION`	`VARCHAR2(128)`		Classification associated with the level
`VALUE`	`CLOB`		Value of the classification, or NULL if not specified
`LANGUAGE`	`VARCHAR2(64)`		`NLS_LANGUAGE` value associated with the classification, or NULL if not specified
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the classification in the list of classifications associated with the level
`ORIGIN_CON_ID`	`NUMBER`		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).
`EDITION_NAME`	`VARCHAR2(128)`		Name of the application edition where the attribute dimension is defined

Note:

This view is available starting with Oracle Database release 21c, version 21.5.

本站中文解释

官方英文解释

相关推荐