Oracle教程 2023-04-01

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

本站中文解释

ALL_ATTRIBUTE_DIM_LEVELS_AE视图是Oracle数据库中用于管理、检索方案属性子层级信息的内部系统视图。

它可以用来检索相关的方案属性子层级信息，其中有模式的名称，潜在的子层属性类型，控制的属性及父节点等信息。

视图的使用举例如下：

SELECT ATTRIBUTE_LEVEL, ATTRIBUTE_LEVEL_LABEL, ATTRIBUTE_LEVEL_TYPE, ATTRIBUTE_TYPE
FROM ALL_ATTRIBUTE_DIM_LEVELS_AE
WHERE ATTRIBUTE_NAME = ‘State’
AND SCHEMA_NAME = ‘my_schema’;

上述查询将检索出my_schema模式中“State”属性名称下所有子层级信息，其中包括属性级别(ATTRIBUTE_LEVEL)，属性级别标签(ATTRIBUTE_LEVEL_LABEL)，属性级别类型(ATTRIBUTE_LEVEL_TYPE)，属性类型(ATTRIBUTE_TYPE)等内容。

官方英文解释

ALL_ATTRIBUTE_DIM_LEVELS_AE describes the levels of the attribute dimensions (across all editions) accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_LEVELS_AE describes the levels of all attribute dimensions (across all editions) in the database.
USER_ATTRIBUTE_DIM_LEVELS_AE describes the levels of the attribute dimensions (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 attribute dimension
`DIMENSION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the attribute dimension
`LEVEL_NAME`	`VARCHAR2(128)`		Name of the attribute dimension level
`SKIP_WHEN_NULL`	`VARCHAR2(1)`		Indicates whether to skip the level when the key is NULL; the value can be `Y` or `N`.
`LEVEL_TYPE`	`VARCHAR2(10)`		Type of attribute dimension level
`MEMBER_NAME_EXPR`	`CLOB`	`NOT NULL`	Expression representing the level member name
`MEMBER_CAPTION_EXPR`	`CLOB`		Expression representing the level member caption, or NULL if not specified
`MEMBER_DESCRIPTION_EXPR`	`CLOB`		Expression representing the level member description, or NULL if not specified
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the level in the list of attribute dimension levels
`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 attribute dimension is defined

Note:

This view is available starting with Oracle Database release 21c, version 21.5.

本站中文解释

官方英文解释

相关推荐