Oracle 视图 ALL_MEASURE_FOLDERS 官方解释，作用，如何使用详细说明
本站中文解释
视图
ALL_MEASURE_FOLDERS视图是Oracle数据库中特殊的视图，用于查询有关特定的OLAP数据库的度量文件夹信息。
可以使用ALL_MEASURE_FOLDERS视图来查找一组度量文件夹的属性，包括文件夹的ID，名称，描述和类型（内建或定制），以及所有者。
为了使用ALL_MEASURE_FOLDERS视图，首先要连接到Oracle数据库，然后使用SQL语句查询视图。例如，下面的SQL语句会返回有关度量文件夹的所有信息：
SELECT * FROM ALL_MEASURE_FOLDERS;
官方英文解释
ALL_MEASURE_FOLDERS describes the OLAP measure folders accessible to the current user.
Related Views
-
DBA_MEASURE_FOLDERSdescribes all OLAP measure folders in the database. -
USER_MEASURE_FOLDERSdescribes the OLAP measure folders owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the measure folder |
|
|
|
|
Name of a measure folder |
|
|
|
|
ID of a measure folder |
|
|
|
Description of the measure folder in the session language |
See Also:
-
“DBA_MEASURE_FOLDERS”
-
“USER_MEASURE_FOLDERS”
