Oracle教程 2023-02-25

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

ALL_ATTRIBUTE_DIM_CLASS视图是Oracle数据字典（Data Dictionary）视图中的一种，可以用来查询模式自引用维度表状键列中属性列的类型。

ALL_ATTRIBUTE_DIM_CLASS视图的用途是跟踪和管理内部维度表中的数据类型以及它们之间的关系。这对于从维表中检索数据和用于有些数据编码列的准确定义非常重要。

使用ALL_ATTRIBUTE_DIM_CLASS视图非常简单，只需执行用于检索所有属性类型的SELECT语句即可：
select * from all_attribute_dim_class;

该语句将会显示视图中所有属性类型的信息，以及它们之间的关系。例如，它可以为你展示属性列类型是什么，这些属性中有没有属于同一类型，以及其它有关细节。

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

Related Views

DBA_ATTRIBUTE_DIM_CLASS describes the classifications of all attribute dimensions in the database.
USER_ATTRIBUTE_DIM_CLASS describes the 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
`CLASSIFICATION`	`VARCHAR2(128)`		Classification associated with the attribute dimension
`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 dimension
`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).