Oracle教程 2023-03-24

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

ALL_DIM_LEVELS是Oracle数据库中查询ALL_CUBES中列出的所有多维数组中每个维度（也叫维）的级别信息的内容视图（视图）。

一般情况下，多维数组中的每个维度都会有一个或多个级别，比如上市、次上市、终端等。有时候，通过分析的多维数据集，可以更好地了解每个维度在不同级别的信息，从而更加深刻地了解其中的规律。

使用ALL_DIM_LEVELS视图的一般方式是通过ALL_CUBES查看某多维数组的基本信息，然后查询关联的ALL_DIM_LEVELS视图，从而查看某多维数组的每个维度级别和对应的维度名称信息。

ALL_DIM_LEVELS describes the dimension levels accessible to the current user. All columns of a dimension level must come from the same relation.

Related Views

DBA_DIM_LEVELS describes all dimension levels in the database.
USER_DIM_LEVELS describes the levels of all dimensions owned by the current user.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the dimension
`DIMENSION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the dimension
`LEVEL_NAME`	`VARCHAR2(128)`		Unique within a dimension
`NUM_COLUMNS`	`NUMBER`		Number of columns in the level definition
`DETAILOBJ_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the detail object that the keys of this level come from
`DETAILOBJ_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table that the keys of this level come from
`SKIP_WHEN_NULL`	`VARCHAR2(1)`		Indicates whether the level is declared with the `SKIP WHEN NULL` clause (`Y`) or not (`N`)