Oracle 视图 USER_ANALYTIC_VIEW_HIER_CLS_AE 官方解释,作用,如何使用详细说明
本站中文解释
是 Oracle 中一种视图,它是用于分析大型工作负载的、可快速查找、层次排序和汇总数据的实用程序,在 Oracle 做大量的负载时可有效的实现数据的层次加载。
使用方法:
1. 使用 SQL 语句创建 USER_ANALYTIC_VIEW_HIER_CLS_AE 视图:
CREATE OR REPLACE VIEW USER_ANALYTIC_VIEW_HIER_CLS_AE AS
SELECT col1,…. coln
FROM some_table;
2. 通过 USER_ANALYTIC_VIEW_HIER_CLS_AE 视图查看列:
SELECT col1,…. coln
FROM USER_ANALYTIC_VIEW_HIER_CLS_AE;
3. 使用 USER_ANALYTIC_VIEW_HIER_CLS_AE 视图进行层次加载:
SELECT col1,…. coln
FROM USER_ANALYTIC_VIEW_HIER_CLS_AE
WHERE start_date >= TO_DATE(‘2030-03-01’, ‘YYYY-MM-DD’);
官方英文解释
USER_ANALYTIC_VIEW_HIER_CLS_AE
describes the classifications of the hierarchies in the analytic views (across all editions) owned by the current user. Its columns (except for OWNER
) are the same as those in ALL_ANALYTIC_VIEW_HIER_CLS_AE
.
Note:
This view is available starting with Oracle Database release 21c, version 21.5.
See Also:
“ALL_ANALYTIC_VIEW_HIER_CLS_AE”