Oracle教程 2023-04-07

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

本站中文解释

ALL_ATTRIBUTE_DIM_LVL_CLASSES 视图可以用来查询在当前用户下可用的、具有所有维度属性和维度级别的指定分类集。该视图包括三列：LEVEL_UNIQUE_NAME、OBJECT_TYPE 和 ATTRIBUTE_NAME；其中LEVEL_UNIQUE_NAME定义了维度级别的唯一名称、OBJECT_TYPE指示维度的类型(DIMENSION、HIERARCHY、LEVEL等)，而ATTRIBUTE_NAME则对应于对象的属性。

例如，要查询当前用户具有的分类集“ABCD”中定义的所有维度属性和维度级别，可以使用ALL_ATTRIBUTE_DIM_LVL_CLASSES视图：

SELECT LEVEL_UNIQUE_NAME, OBJECT_TYPE, ATTRIBUTE_NAME
FROM ALL_ATTRIBUTE_DIM_LVL_CLASSES
WHERE CLASS_NAME = ‘ABCD’;

官方英文解释

ALL_ATTRIBUTE_DIM_LVL_CLASS describes the level classifications of the attribute dimensions accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_LVL_CLASS describes the level classifications of all attribute dimensions in the database.
USER_ATTRIBUTE_DIM_LVL_CLASS describes the level 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
`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).

本站中文解释

官方英文解释

相关推荐