Oracle 视图 ALL_MEASURE_FOLDER_SUBFOLDERS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_MEASURE_FOLDER_SUBFOLDERS是一个可以查询指定文件夹中所有子文件夹及其属性的视图。可以用来查看某个文件夹的结构，以及子文件夹的细节。本视图的主要用途是方便用户查看某文件夹下的所有子文件夹。
要使用此视图，可以使用如下的SQL查询：
SELECT * FROM ALL_MEASURE_FOLDER_SUBFOLDERS WHERE FOLDER_NAME = ‘任意目录名’;
其中，FOLDER_NAME参数中填写要查询的文件夹名称，将会查询出此目录及其所有子文件夹的属性。
官方英文解释
ALL_MEASURE_FOLDER_SUBFOLDERS describes the OLAP measure folders contained within the OLAP measure folders accessible to the user.
Related Views
-
DBA_MEASURE_FOLDER_SUBFOLDERSdescribes the OLAP measure folders contained within the database OLAP measure folders. -
USER_MEASURE_FOLDER_SUBFOLDERSdescribes the OLAP measure folders contained within the OLAP measure folders owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the OLAP measure folder that contains a subfolder |
|
|
|
|
Name of the OLAP measure folder that contains a subfolder |
|
|
|
|
Owner of the OLAP measure folder subfolder |
|
|
|
|
Name of the owning OLAP measure folder subfolder |
See Also:
-
“DBA_MEASURE_FOLDER_SUBFOLDERS”
-
“USER_MEASURE_FOLDER_SUBFOLDERS”
