Oracle 视图 ALL_ANALYTIC_VIEW_LVLGRPS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_ANALYTIC_VIEW_LVLGRPS 是 Oracle 中的一个视图，它的用途是，通过每个用户的权限，来查询analytic view的等级分组定义，最多支持8组分组，即可提供多种查询维度，可以方便调整约束以及对某维度进行抽取，以及关联和多维查询中的结果改变等。
即，可通过 ALL_ANALYTIC_VIEW_LVLGRPS 视图来查询和管理用户拥有的 视图分组等级权限。
要使用此视图，可以执行如下查询：
SELECT *
FROM ALL_ANALYTIC_VIEW_LVLGRPS
WHERE USERNAME=’用户名’;
此查询将返回用户的视图分组等级的详细信息。
官方英文解释
ALL_ANALYTIC_VIEW_LVLGRPS describes the analytic view measure and level groups of the analytic views accessible to the current user.
Related Views
-
DBA_ANALYTIC_VIEW_LVLGRPSdescribes the analytic view measure and level groups of all analytic views in the database. -
USER_ANALYTIC_VIEW_LVLGRPSdescribes the analytic view measure and level groups of the analytic views owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the analytic view |
|
|
|
|
Name of the analytic view |
|
|
|
|
Type of the materialized view; one of the following:
|
|
|
|
|
Alias of the attribute dimension in the group |
|
|
|
|
Alias of the hierarchy associated with the attribute dimension in the group |
|
|
|
|
Name of the level in the hierarchy in the group |
|
|
|
|
Names of the measures in the group |
|
MAT_TABLE_OWNERFoot 1 |
VARCHAR2(128) |
If the schema for an aggregation table is specified for the analytic view, then the schema owner; otherwise NULL |
|
MAT_TABLE_NAMEFoot 1 |
VARCHAR2(128) |
If an aggregation table is specified for an analytic view, then the name of the materialized table; otherwise NULL |
|
|
|
|
Order of the groups in the analytic view |
|
|
|
|
Order of the levels and measures in the group |
|
|
|
|
The ID of the container where the data originates. Possible values include:
|
Footnote 1 This column is available starting with Oracle Database 21c.
See Also:
-
“DBA_ANALYTIC_VIEW_LVLGRPS”
-
“USER_ANALYTIC_VIEW_LVLGRPS”
