Oracle教程 2023-02-27

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

是一个 Oracle 数据库中的视图，主要用于查看基于维度分析技术而构建的维度属性分区视图中，维度属性与度量属性之间的排序。

该视图根据子维度把属性细分为从父到子的顺序，可以显示出各个属性的等级关系。

使用方法是通过 select 语句来检索视图的信息，如：select * from all_attribute_dim_order_attrs;

可以使用视图查询列出该维度属性分区视图中维度属性的排列顺序，以及在关联的度量表中的排列顺序，并可使用DBA_ATTRIBUTE_DIM_ORDER_ATTRS视图进行检索。检索信息如：属性名称、度量表列表、排列顺序等。

ALL_ATTRIBUTE_DIM_ORDER_ATTRS describes the order attributes of the attribute dimensions accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_ORDER_ATTRS describes the order attributes of all attribute dimensions in the database.
USER_ATTRIBUTE_DIM_ORDER_ATTRS describes the order 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
`LEVEL_NAME`	`VARCHAR2(128)`		Name of the level to order or the name of the level that has the `ORDER` `BY` clause
`AGG_FUNC`	`VARCHAR2(3)`		Aggregation function of the `ORDER` `BY` clause: `MIN` `MAX`
`ATTRIBUTE_NAME`	`VARCHAR2(128)`		Name of the order attribute
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order number of the attribute in the list of order attributes
`CRITERIA`	`VARCHAR2(4)`		Criteria of the ordering, either ascending or descending: `ASC` `DESC`
`NULLS_POSITION`	`VARCHAR2(5)`		Position of `ORDER` `BY` values in the orderings: `FIRST` `LAST`
`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).