Oracle教程 2023-03-31

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

ALL_ATTRIBUTE_DIM_ATTR_CLASS_T 是 Oracle 数据库中的视图，它通过属性维度组合出特定的属性内容，以便进行统计和分析报表等。

使用方法：

1. 使用All_ATTRIBUTE_DIM_ATTR_CLASS_T视图可以查找属性列表中是否存在特定的属性内容；

2. 使用All_ATTRIBUTE_DIM_ATTR_CLASS_T视图可以筛选出输入属性条件返回相关的属性内容；

3. 使用All_ATTRIBUTE_DIM_ATTR_CLASS_T视图可以将属性列表中的内容以图形报表的形式展示出来；

4. 使用All_ATTRIBUTE_DIM_ATTR_CLASS_T视图可以对属性列表中特定属性内容进行排序；

ALL_ATTRIBUTE_DIM_ATTR_CLASS describes the attribute classifications of the attribute dimensions accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_ATTR_CLASS describes the attribute classifications of all attribute dimensions in the database.
USER_ATTRIBUTE_DIM_ATTR_CLASS describes the attribute classifications of the attribute dimensions 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
`ATTRIBUTE_NAME`	`VARCHAR2(128)`		Name of the attribute
`CLASSIFICATION`	`VARCHAR2(128)`		Classification associated with the attribute
`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 attribute
`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).