Oracle教程 2023-02-23

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

Oracle视图ALL_ANALYTIC_VIEW_CLASS_AE是Oracle字段类库中的一种视图，它包含一系列信息关于在当前用户模式下所有存在的分析视图类别。

其字段如下：

CLASS_NAME：分析视图类别的名称

CLASS_TYPE：分析视图类别的类型

DESCRIPTION：对分析视图类别的描述

CREATED_DATE：分析视图类别创建时间

LAST_CHANGED_DATE：分析视图类别最后一次修改时间

CREATED_BY：分析视图类别创建者

LAST_CHANGED_BY：分析视图类别最后一次修改者。

ALL_ANALYTIC_VIEW_CLASS_AE视图的用途主要是检索分析视图类别的信息。使用该视图时，可以获取特定类别的详细信息，例如最后一次更改的时间、创建者和修改者的名称等。

我们可以使用以下SQL查询来使用该视图。

SELECT
CLASS_NAME,
CLASS_TYPE,
DESCRIPTION,
CREATED_DATE,
LAST_CHANGED_DATE,
CREATED_BY
FROM
ALL_ANALYTIC_VIEW_CLASS_AE;

ALL_ANALYTIC_VIEW_CLASS_AE describes the classifications of the analytic views (across all editions) accessible to the current user.

Related Views

DBA_ANALYTIC_VIEW_CLASS_AE describes the classifications of all analytic views (across all editions) in the database.
USER_ANALYTIC_VIEW_CLASS_AE describes the classifications of the analytic views (across all editions) 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 analytic view
`ANALYTIC_VIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the analytic view
`CLASSIFICATION`	`VARCHAR2(128)`		Classification associated with the analytic view
`VALUE`	`CLOB`		Value of the classification or NULL if not specified
`LANGUAGE`	`VARCHAR2(64)`		`NLS_LANGUAGE` value associated with the classification or NULL if not specified
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the classification in the list of classifications associated with the analytic view
`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).
`EDITION_NAME`	`VARCHAR2(128)`		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.