Oracle教程 2023-03-20

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

本站中文解释

视图

ALL_ATTRIBUTE_DIM_JOIN_PATHS视图可以提供维度联接路径的信息，它将提供维表之间的连接。此视图只提供当前拥有者维表之间的连接条件。

此视图中包含以下字段：

– DIMENSION_PATH: 维度路径，指定维表之间的连接条件
– JOIN_PATH_SEQ：维表之间连接路径的序列号，由数字组成的字符串，该字符串中的数字按由底向上的层次排列维表。
– JOIN_CONDITION：联接条件
– START_LEVEL：联接路径的起始层
– END_LEVEL：联接路径的末尾层
– DIM_SEQ：当前维表所在层级
– STAGE_NO：联接路径的步骤号

可以使用以下SQL语句查看ALL_ATTRIBUTE_DIM_JOIN_PATHS视图中的信息：

“`sql
SELECT *
FROM ALL_ATTRIBUTE_DIM_JOIN_PATHS
WHERE OWNER_NAME = ”;
“`

官方英文解释

ALL_ATTRIBUTE_DIM_JOIN_PATHS describes the join paths for the attribute dimensions accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_JOIN_PATHS describes the join paths for all attribute dimensions in the database.
USER_ATTRIBUTE_DIM_JOIN_PATHS describes the join paths for 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
`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).

本站中文解释

官方英文解释

相关推荐