本站中文解释
:
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_AEdescribes the join paths for all attribute dimensions (across all editions) in the database. -
USER_ATTRIBUTE_DIM_JN_PTHS_AEdescribes the join paths for the attribute dimensions (across all editions) owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the attribute dimension |
|
|
|
|
Name of the attribute dimension |
|
|
|
|
Name of the join path |
|
|
|
Join condition specified in the |
|
|
|
|
|
Order of the classification in the list of classifications associated with the attribute dimension |
|
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
|
|
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.
See Also:
-
“DBA_ATTRIBUTE_DIM_JN_PTHS_AE”
-
“USER_ATTRIBUTE_DIM_JN_PTHS_AE”