Oracle教程 2023-04-03

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

ALL_ATTRIBUTE_DIM_ATTRS视图是Oracle内部准备的用来获取属性维度中属性及对应信息的表，也就是我们常说的维度属性表，这个维度表中会包含着各种维度中的维度属性信息，比如地域维度中的市、区的信息。

使用Oracle的ALL_ATTRIBUTE_DIM_ATTRS视图可以快速查询某个维度中的属性及其对应的属性分值，范例如下：

SELECT * FROM ALL_ATTRIBUTE_DIM_ATTRS WHERE dim_name = ‘地域维度’

上述的SQL语句是用来查询地域维度下的所有属性及其分值。

ALL_ATTRIBUTE_DIM_ATTRS describes the attributes of the attribute dimensions accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_ATTRS describes the attributes of all attribute dimensions in the database.
USER_ATTRIBUTE_DIM_ATTRS describes the attributes 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 dimension attribute
`TABLE_ALIAS`	`VARCHAR2(128)`		Alias of the table or view in the `USING` clause to which the column belongs
`COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the column in the table or view on which the attribute is defined
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the attribute in the list of attribute dimension attributes
`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).