Oracle教程 2023-02-23

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

Oracle视图ALL_ATTRIBUTE_DIM_JN_PTHS_AE是一个用于检索有关维度主路径属性的视图。

它能够检索属性的名称、位置、顺序、等参数，以及属性值列表。这些参数将有助于确定维度主路径的全部属性信息。

此外，视图中还包含了以属性标识开头的”列定义”，可以提供有关属性值的更多信息，包括可否为空、最小值、最大值等。

可以使用此视图向维度结构添加主路径，或检索所有与现有维度定义相关的信息。可以使用SELECT语句检索此视图中的数据。例如，可以使用以下SELECT语句检索当前有效维度的属性的完整信息：

SELECT * FROM all_attribute_dim_jn_pths_ae WHERE dim_id = ‘ABC’ AND valid_flag = ‘Y’ ;

ALL_ATTRIBUTE_DIM_JN_PTHS_AE describes the join paths for the attribute dimensions (across all editions) accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_JN_PTHS_AE describes the join paths for all attribute dimensions (across all editions) in the database.
USER_ATTRIBUTE_DIM_JN_PTHS_AE describes the join paths for the attribute dimensions (across all editions) owned by the current user.

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
`JOIN_PATH_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the join path
`ON_CONDITION`	`VARCHAR2(4000)`		Join condition specified in the `ON` clause
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the classification in the list of classifications associated with the attribute dimension
`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.