Oracle教程 2023-03-24

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

ALL_ATTRIBUTE_DIM_KEYS是一个Oracle数据库中的视图，用于描述特定属性维度及其属性值之间的关系。

它用于访问、检索和更新特定维度和其属性对应的键值。它也可以用于构建高效的属性绑定，以支持属性维度绑定应用，如决策支持系统和数据仓库应用。

要使用这个视图，用户必须使用select语句，指定特定的维度和其属性，以获取其键值。

ALL_ATTRIBUTE_DIM_KEYS describes the keys of the attribute dimensions accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_KEYS describes the keys of all attribute dimensions in the database.
USER_ATTRIBUTE_DIM_KEYS describes the keys 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
`LEVEL_NAME`	`VARCHAR2(128)`		Name of the level of the key
`IS_ALTERNATE`	`VARCHAR2(1)`		Indicates whether the attribute dimension key is an alternate key (`Y`) or not (`N`)
`ATTRIBUTE_NAME`	`VARCHAR2(128)`		Name of the key attribute
`ATTR_ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the attribute in the list of attributes comprising the key
`KEY_ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the key in the list of keys (if alternate keys are specified)
`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).