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_FOLDERS describes all OLAP measure folders in the database.

  • USER_MEASURE_FOLDERS describes the OLAP measure folders owned by the current user. This view does not display the OWNER column.

ColumnDatatypeNULLDescription

OWNER

VARCHAR2(128)

NOT NULL

Owner of the measure folder

MEASURE_FOLDER_NAME

VARCHAR2(128)

NOT NULL

Name of a measure folder

MEASURE_FOLDER_ID

NUMBER

NOT NULL

ID of a measure folder

DESCRIPTION

NVARCHAR2(300)

Description of the measure folder in the session language

See Also:

  • “DBA_MEASURE_FOLDERS”

  • “USER_MEASURE_FOLDERS”