Oracle 视图 ALL_ANALYTIC_VIEW_FCT_COLS_AE 官方解释,作用,如何使用详细说明
本站中文解释
ALL_ANALYTIC_VIEW_FCT_COLS_AE 是Oracle数据库中用于查看某个查询分析视图(Analytic View)中每个分析函数(Analytic Function)所使用的字段的系统视图。它包含某个查询分析视图中每个分析函数所使用的字段及其他信息。
使用方法:
1.连接到Oracle数据库。
2.查询ALL_ANALYTIC_VIEW_FCT_COLS_AE视图:SELECT * FROM ALL_ANALYTIC_VIEW_FCT_COLS_AE WHERE ANALYTICVIEWNAME=’view_name’;
其中,view_name是要查询的查询分析视图的名称。
3.通过该查询,可以获取该查询分析视图中每个分析函数所使用的字段及其他信息。
官方英文解释
ALL_ANALYTIC_VIEW_FCT_COLS_AE
describes the fact columns of the analytic views (across all editions) accessible to the current user.
Related Views
-
DBA_ANALYTIC_VIEW_FCT_COLS_AE
describes the fact columns of all analytic views (across all editions) in the database. -
USER_ANALYTIC_VIEW_FCT_COLS_AE
describes the fact columns of the analytic views (across all editions) owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
NOT NULL |
Owner of the analytic view |
|
|
NOT NULL |
Name of the analytic view |
|
|
|
Alias of the fact table in the analytic view |
|
|
NOT NULL |
Name of the column |
|
|
NOT NULL |
Alias of the column. Use this value as the identifier for the fact column in a query. |
|
|
NOT NULL |
Order of the column in the fact table |
|
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
Name of the application edition where the analytic view is defined |
Note:
This view is available starting with Oracle Database release 21c, version 21.5.
See Also:
-
“DBA_ANALYTIC_VIEW_FCT_COLS_AE”
-
“USER_ANALYTIC_VIEW_FCT_COLS_AE”