Oracle教程 2023-03-21

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

ALL_HIER_JOIN_PATHS视图用来发现在查询过程中被用作会话时注册的等级关系表之间的连接路径。它显示了从参照表的顶点到被索引表的顶点的最短变换路径，这些路径可能是多边形或树状结构。

使用ALL_HIER_JOIN_PATHS视图时，需要指定要检索的会话标识符。例如，使用以下查询来检索包含在另一视图中指定会话标识符中注册的等级关系表之间的最近结合路径：

SELECT * FROM ALL_HIER_JOIN_PATHS WHERE session_id=’session_id’;

ALL_HIER_JOIN_PATHS describes the join paths for the hierarchies accessible to the current user.

Related Views

DBA_HIER_JOIN_PATHS describes the join paths for all hierarchies in the database.
USER_HIER_JOIN_PATHS describes the join paths for the hierarchies 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 hierarchy
`HIER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the hierarchy
`JOIN_PATH_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the join path
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the classification in the list of join paths associated with the hierarchy
`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).