Oracle教程 2023-03-23

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

本站中文解释

_MN

Oracle视图ALL_ANALYTIC_VIEW_LEVEL_CLASS_MN用于维护数据仓库中各类分析视图的表结构，以及各层次之间的依赖关系。它可以帮助组织构建一个可追溯的分析体系结构，并标记这些关系，以便进行更高层次的维护和管理。

使用ALL_ANALYTIC_VIEW_LEVEL_CLASS_MN视图，可以查询数据仓库中不同层次的分析视图之间的关联关系，或者找到需要维护或更新的某个分析视图。要使用该视图，必须首先运行以下语句：SELECT * FROM ALL_ANALYTIC_VIEW_LEVEL_CLASS_MN ；后，可以使用多种查询条件来筛选特定的视图，如需要查询特定层次的分析视图，则可以使用如下查询语句：SELECT * FROM ALL_ANALYTIC_VIEW_LEVEL_CLASS_MN WHERE LEVEL_ID = ‘X’ ；

官方英文解释

ALL_ANALYTIC_VIEW_LEVEL_CLASS describes the level classifications of the analytic views accessible to the current user.

Related Views

DBA_ANALYTIC_VIEW_LEVEL_CLASS describes the level classifications of all analytic views in the database.
USER_ANALYTIC_VIEW_LEVEL_CLASS describes the level classifications of the analytic views 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 analytic view
`ANALYTIC_VIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of analytic view
`DIMENSION_ALIAS`	`VARCHAR2(128)`		Alias of the analytic view dimension in the analytic view
`HIER_ALIAS`	`VARCHAR2(128)`		Alias of the hierarchy in the analytic view
`LEVEL_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the level in the analytic view
`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).

本站中文解释

官方英文解释

相关推荐