Oracle教程 2023-04-02

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

Oracle视图ALL_ZONEMAP_MEASURES的用途是查询坐标系统中所有的空间因子测量值。可以用来检索坐标系统定义的公差和有效性范围，以及坐标系统图形元素的比例尺。

使用ALL_ZONEMAP_MEASURES视图来查询可以使用以下语句：

SELECT srs_name, measure_name, measure_value FROM all_zones_map_measures WHERE measure_name = ‘Tolerance’;

ALL_ZONEMAP_MEASURES describes the measures for all zone maps accessible to the user.

Related Views

DBA_ZONEMAP_MEASURES describes the measures for all the zone maps in the database.
USER_ZONEMAP_MEASURES describes the measures for all the zone maps owned by the user.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the zone map
`ZONEMAP_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the zone map
`MEASURE`	`LONG`		Column whose `MIN/MAX` value is computed
`POSITION_IN_SELECT`	`NUMBER`	`NOT NULL`	Original position of the mesaure aggregate on the `SELECT` list of zone map defining query
`AGG_FUNCTION`	`VARCHAR2(13)`		Name of aggregate in zone map table
`AGG_COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the column whose `MIN/MAX` per zone maintained

Note:

This view is intended for use with Oracle Exadata release 12.1.2.1.1 or later.