Oracle教程 2023-02-27

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

Oracle试图可以帮助用户获取数据库中特定信息，而不用直接查询实际表格。 ALL_ATTRIBUTE_DIM_ORD_ATRS_AE是Oracle中的视图，它用来查询销售订单中特征活动信息，其中映射字段包括：

– ORDER_ID：订单ID
– SEQ_NO：订单特征号
– DIMENSION_CODE：维度编码
– ATTRIBUTE_CODE：属性编码
– ATTRIBUTE_VALUE：属性值
– DISPLAY_VALUE：显示值

举个例子，可以使用视图ALL_ATTRIBUTE_DIM_ORD_ATRS_AE查询某个特定订单的所有特征活动，通过如下语句：

SELECT * FROM ALL_ATTRIBUTE_DIM_ORD_ATRS_AE WHERE ORDER_ID=’your_order_id’;

该查询将返回特定订单ID下所有特征活动信息，例如上述6个映射字段。

ALL_ATTRIBUTE_DIM_ORD_ATRS_AE describes the order attributes of the attribute dimensions (across all editions) accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_ORD_ATRS_AE describes the order attributes of all attribute dimensions (across all editions) in the database.
USER_ATTRIBUTE_DIM_ORD_ATRS_AE describes the order attributes of the attribute dimensions (across all editions) 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).
`EDITION_NAME`	`VARCHAR2(128)`		Name of the application edition where the attribute dimension is defined

Note:

This view is available starting with Oracle Database release 21c, version 21.5.