Oracle 视图 ALL_ANALYTIC_VIEW_DIMENSIONS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle 视图 ALL_ANALYTIC_VIEW_DIMENSIONS 用于查询通过关系型数据视图 M_RS_VIEW_COLUMNS 构建的各个分析视图中可使用的维度列信息,包括列名、类型、长度、是否可为空等信息。
使用方法:
该视图提供了以下查询字段:
VIEW_NAME:视图名称。
COLUMN_NAME:维度字段名称。
DATA_TYPE:维度字段类型。
DATA_LENGTH:维度字段长度。
NULLABLE:该字段是否可为空。
使用方式:通过指定视图名称,查询该视图所有可用的维度字段:
SELECT * FROM ALL_ANALYTIC_VIEW_DIMENSIONS WHERE VIEW_NAME = ‘view_name’;
官方英文解释
ALL_ANALYTIC_VIEW_DIMENSIONS
describes the attribute dimensions in the analytic views accessible to the current user.
Related Views
-
DBA_ANALYTIC_VIEW_DIMENSIONS
describes the attribute dimensions in all analytic views in the database. -
USER_ANALYTIC_VIEW_DIMENSIONS
describes the attribute dimensions in the analytic views owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the analytic view |
|
|
|
Name of the analytic view |
|
|
|
Owner of the schema containing the attribute dimension |
|
|
|
Name of the attribute dimension |
|
|
Alias of the attribute dimension in the analytic view |
|
|
|
Type of the attribute dimension:
|
|
|
|
An expression for the name of the ALL member for the attribute dimension |
|
|
|
An expression for the caption for the ALL member of the attribute dimension, or NULL if not specified |
|
|
|
An expression for the description for the ALL member of the attribute dimension, or NULL if not specified |
|
|
|
Indicates whether the reference between the fact table key and the attribute dimension attribute specifies the
|
|
|
|
|
Order number of the attribute dimension in the analytic view |
|
|
The ID of the container where the data originates. Possible values include:
|
See Also:
-
“DBA_ANALYTIC_VIEW_DIMENSIONS”
-
“USER_ANALYTIC_VIEW_DIMENSIONS”