Index

0

SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 13

type 0 (zero) element, 2.3.6

_3D

formats of LRS functions, 6.4

9i

migrating to Oracle9i, 15

aggregate functions

description, 1.9

reference information, 12

SDO_AGGR_CENTROID, 12

SDO_AGGR_CONVEXHULL, 12

SDO_AGGR_LRS_CONCAT, 12

SDO_AGGR_MBR, 12

SDO_AGGR_UNION, 12

SDOAGGRTYPE object type, 1.9.1

ALL_SDO_GEOM_METADATA view, 2.4

ALL_SDO_INDEX_INFO view, 2.5.1.1

ALL_SDO_INDEX_METADATA view, 2.5.1.2

ALTER INDEX statement, 8

REBUILD clause, 8

RENAME TO clause, 8

ANALYZE_RTREE procedure, 16

angle units, 5.4.2

ANYINTERACT mask relationship, 11

application size (hardware) requirements, 1.13

arc

densifying, 11

not supported with geodetic data, 5.2.3

area, 11

authalic sphere, 5.1.7

average minimum bounding rectangle, 16

AVERAGE_MBR procedure, 16

bounding rectangle

minimum, 16

buffer area, 11

bulk loading of spatial data, 3.1

C language

examples (using OCI), 1.15

Cartesian coordinates, 1.5.4, 5.1.2

center of gravity (centroid), 11

centroid

SDO_AGGR_CENTROID aggregate function, 12

SDO_CENTROID function, 11

circle

not supported with geodetic data, 5.2.3

type, 2.2.4

CLIP_GEOM_SEGMENT function, 14

clipping a geometric segment, 6.5.3

column name

restrictions on spatial column names, 2.4.2

COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2.4.2

compatibility, A

compound element, 2.2.4

compound line string, 2.2.4, 2.3.3

compound polygon, 2.2.4

CONCATENATE_GEOM_SEGMENTS function, 14

concatenating geometric segments, 6.5.5

aggregate concatenation, 6.5.5, 12

CONNECTED_GEOM_SEGMENTS function, 14

consistency

checking for valid geometry types, 11, 11

constraining data to a geometry type, 4.1.5

CONTAINS mask relationship, 11

CONVERSION_FACTOR column

in SDO_ANGLE_UNITS table, 5.4.2

in SDO_AREA_UNITS table, 2.6

in SDO_DIST_UNITS table, 2.6

CONVERSION_FACTOR column in SDO_DIST_UNITS table, 5.4.3

CONVERT_TO_LRS_DIM_ARRAY function, 14

CONVERT_TO_LRS_GEOM function, 14

CONVERT_TO_LRS_LAYER function, 14

CONVERT_TO_STD_DIM_ARRAY function, 14

CONVERT_TO_STD_GEOM function, 14

CONVERT_TO_STD_LAYER function, 14

converting

geometric segments

functions for, 14

overview, 6.5.10

convex hull

SDO_AGGR_CONVEXHULL aggregate function, 12

SDO_CONVEXHULL function, 11

coordinate systems

conceptual and usage information, 5

example, 5.8

function reference information, 13

local, 5.3

user-defined, 5.5

coordinates

Cartesian, 1.5.4, 5.1.2

geodetic, 1.5.4, 5.1.3, 5.2

geographic, 1.5.4, 5.1.3

local, 1.5.4, 5.1.5

projected, 1.5.4, 5.1.4

COVEREDBY mask relationship, 11

COVERS mask relationship, 11

CPU requirements for spatial applications, 1.13

CREATE INDEX statement, 8

creating

geometric segments

functions for, 14

cross-schema index creation, 4.1.6

CS_SRS table, 5.4.1

current release

migrating to, 15

data model, 1.5

LRS, 6.2

data types

spatial, 2

datum

geodetic, 1.5.4, 5.1.6

MDSYS.SDO_DATUMS table, 5.4.4

transformation, 5.1.8

DBA_SDO_GEOM_METADATA view, 2.4

DBA_SDO_INDEX_INFO view, 2.5.1.1

DBA_SDO_INDEX_METADATA view, 2.5.1.2

deferred index updates, 8

DEFINE_GEOM_SEGMENT function, 14

defining a geometric segment, 6.5.1

densification of arcs, 11

difference, 11

dimension (in SDO_GTYPE), 2.2.1, 2.2.1

GET_DIMS method, 9

GET_LRS_DIM method, 9

DIMINFO (in USER_SDO_GEOM_METADATA), 2.4.3

direction of geometric segment, 6.1.3

concatenation result, 6.5.5

DISJOINT mask relationship, 11

disk storage requirements for spatial applications, 1.13

distance

SDO_NN_DISTANCE ancillary operator, 10

WITHIN_DISTANCE function, 11

distance units, 5.4.3

DROP INDEX statement, 8

dynamic query window, 4.2.1

DYNAMIC_SEGMENT function, 14

editing

geometric segments

functions for, 14

ELEM_INFO (SDO_ELEM_INFO), 2.2.4

element, 1.5.1

extracting from a geometry, 17

ellipsoids, 5.4.5

embedded SDO_GEOMETRY object in user-defined type, 7.1

EQUAL mask relationship, 11

error messages

Spatial, 1.14

ESTIMATE_INDEX_PERFORMANCE function, 16

ESTIMATE_TILING_LEVEL function, 16

ESTIMATE_TILING_TIME function, 16

ESTIMATE_TOTAL_NUMTILES function, 16

ETYPE (SDO_ETYPE), 2.2.4

examples

C, 1.15

coordinate systems, 5.8

creating, indexing, and querying spatial data, 2.1

directory for Spatial examples, 1.15

Linear Referencing System (LRS), 6.6

OCI (Oracle Call Interface), 1.15

PL/SQL, 1.15

SQL, 1.15

exchanging partitions including indexes, 4.1.8

EXTENT_OF function, 16

exterior polygon rings, 2.2.1, 2.2.4, 2.2.4, 2.3.2, 2.3.2

EXTRACT function, 17

features

linear, 6.1.10

FIND_LRS_DIM_POS function, 14

FIND_MEASURE function, 14

fixed indexing, 1.7.2.2

fixed-size tiles, 4.1.3

FROM_815_TO_81x procedure, 15

function-based index

with SDO_GEOMETRY objects, 7.2

function-based indexes

privilege and session requirements, 7.2

functions and procedures

aggregate (spatial), 12

ANALYZE_RTREE, 16

AVERAGE_MBR, 16

CLIP_GEOM_SEGMENT, 14

CONCATENATE_GEOM_SEGMENTS, 14

CONNECTED_GEOM_SEGMENTS, 14

CONVERT_TO_LRS_DIM_ARRAY, 14

CONVERT_TO_LRS_GEOM, 14

CONVERT_TO_LRS_LAYER, 14

CONVERT_TO_STD_DIM_ARRAY, 14

CONVERT_TO_STD_GEOM, 14

CONVERT_TO_STD_LAYER, 14

coordinate system transformation, 13

DEFINE_GEOM_SEGMENT, 14

DYNAMIC_SEGMENT, 14

ESTIMATE_INDEX_PERFORMANCE, 16

ESTIMATE_TILING_LEVEL, 16

ESTIMATE_TILING_TIME, 16

ESTIMATE_TOTAL_NUMTILES, 16

EXTENT_OF, 16

EXTRACT, 17

FIND_LRS_DIM_POS, 14

FIND_MEASURE, 14

FROM_815_TO_81x, 15

GEOM_SEGMENT_END_MEASURE, 14

GEOM_SEGMENT_END_PT, 14

GEOM_SEGMENT_LENGTH, 14

GEOM_SEGMENT_START_MEASURE, 14

GEOM_SEGMENT_START_PT, 14

geometry, 11

GET_MEASURE, 14

GETVERTICES, 17

HISTOGRAM_ANALYSIS, 16

IS_GEOM_SEGMENT_DEFINED, 14

IS_MEASURE_DECREASING, 14

IS_MEASURE_INCREASING, 14

linear referencing (LRS), 14

LOCATE_PT, 14

MEASURE_RANGE, 14

MEASURE_TO_PERCENTAGE, 14

migration, 15

MIX_INFO, 16

not supported with geodetic data, 5.7.2

OFFSET_GEOM_SEGMENT, 14

OGIS_METADATA_FROM, 15

OGIS_METADATA_TO, 15

PERCENTAGE_TO_MEASURE, 14

PROJECT_PT, 14

QUALITY_DEGRADATION, 16

REDEFINE_GEOM_SEGMENT, 14

RELATE, 11

RESET_MEASURE, 14

REVERSE_GEOMETRY, 14

REVERSE_MEASURE, 14

RTREE_QUALITY, 16

SCALE_GEOM_SEGMENT, 14

SDO_AGGR_CENTROID, 12

SDO_AGGR_CONVEXHULL, 12

SDO_ARC_DENSIFY, 11

SDO_AREA, 11

SDO_BUFFER, 11

SDO_CENTROID, 11

SDO_CONVEXHULL, 11

SDO_DIFFERENCE, 11

SDO_DISTANCE, 11

SDO_INTERSECTION, 11

SDO_LENGTH, 11

SDO_MAX_MBR_ORDINATE, 11

SDO_MBR, 11

SDO_MIN_MBR_ORDINATE, 11

SDO_POINTONSURFACE, 11

SDO_UNION, 11

SDO_XOR, 11

SET_PT_MEASURE, 14

spatial aggregate, 12

SPLIT_GEOM_SEGMENT, 14

supported by approximations with geodetic data, 5.7.3

TO_734, 15

TO_81x, 15

TO_CURRENT, 15

TRANSFORM, 13

TRANSFORM_LAYER, 13

TRANSLATE_MEASURE, 14

tuning, 16

utility, 17

VALID_GEOM_SEGMENT, 14

VALID_LRS_POINT, 14

VALID_MEASURE, 14

VALIDATE_GEOMETRY, 11

VALIDATE_GEOMETRY_WITH_CONTEXT, 11

VALIDATE_LAYER, 11

VALIDATE_LAYER_WITH_CONTEXT, 11

VALIDATE_LRS_GEOMETRY, 14

VIEWPORT_TRANSFORM function, 13

WITHIN_DISTANCE, 11

geocoding, 1.10

geodetic coordinates, 1.5.4, 5.1.3

arcs and circles not supported, 5.2.3

functions not supported, 5.7.2

functions supported by approximations, 5.7.3

support for, 5.2

geodetic datum, 1.5.4, 5.1.6

geodetic index, 4.1.4

geographic coordinates, 1.5.4, 5.1.3

GEOM_SEGMENT_END_MEASURE function, 14

GEOM_SEGMENT_END_PT function, 14

GEOM_SEGMENT_LENGTH function, 14

GEOM_SEGMENT_START_MEASURE function, 14

GEOM_SEGMENT_START_PT function, 14

geometric segment

clipping, 6.5.3

concatenating, 6.5.5

aggregate, 6.5.5, 12

converting (functions for), 14

converting (overview), 6.5.10

creating (functions for), 14

defining, 6.5.1

definition of, 6.1.1

direction, 6.1.3

direction with concatenation, 6.5.5

editing (functions for), 14

locating point on, 6.5.8

offsetting, 6.5.7

projecting point onto, 6.5.9

querying (functions for), 14

redefining, 6.5.2

scaling, 6.5.6

splitting, 6.5.4

geometry functions

reference information, 11

geometry type

constraining data to, 4.1.5

GET_DIMS method, 9

SDO_GTYPE, 2.2.1

geometry types, 1.4

GET_DIMS method, 9

GET_GTYPE method, 9

GET_LRS_DIM method, 9

GET_MEASURE function, 14

GETVERTICES function, 17

GTYPE (SDO_GTYPE), 2.2.1

constraining data to a geometry type, 4.1.5

hardware requirements for spatial applications, 1.13

HISTOGRAM_ANALYSIS procedure, 16

hybrid indexing, B

index

creation, 4.1

cross-schema, 4.1.6

parallel execution, 8

deferred updating, 8

description of Spatial indexing, 1.7

geodetic and non-geodetic, 4.1.4

hybrid, B

partitioned, 4.1.7

exchanging partitions including indexes, 4.1.8

performance, 16

quadtree, 1.7.2

rebuilding

parallel execution, 8

R-tree, 1.7.1

R-tree (requirements before creating), 4.1.1, 4.1.1

synchronizing deferred updates, 8

index-organized table

cannot create spatial index on, 8

inserting spatial data

PL/SQL, 3.2

INSIDE mask relationship, 11

installation, A

installation procedure for Spatial, A.2

INTEPRETATION (SDO_INTERPRETATION), 2.2.4

interaction

ANYINTERACT, 11

interior polygon rings, 2.2.1, 2.2.4, 2.2.4, 2.3.2, 2.3.2

interMedia Locator

See Locator

intersection, 11

inverse flattening, 5.4.5

IS_GEOM_SEGMENT_DEFINED function, 14

IS_MEASURE_DECREASING function, 14

IS_MEASURE_INCREASING function, 14

layer, 1.5.3

transforming, 13

validating, 11

validating with context, 11

layer_gtype

constraining data to a geometry type, 4.1.5

length

SDO_LENGTH function, 11

line

data, 1.5.1

length, 11

line string

compound, 2.2.4, 2.3.3

self-crossing, 1.4

linear features, 6.1.10

linear measure, 6.1.4

Linear Referencing System (LRS)

3D formats of functions, 6.4

conceptual and usage information, 6

data model, 6.2

example, 6.6

function reference information, 14

GET_LRS_DIM method, 9

limiting indexing to X and Y dimensions, 6.3

LRS point, 6.1.9

segments, 6.1.1

upgrading data to current release, A.5

loading spatial data, 3

local coordinate systems, 5.3

local coordinates, 1.5.4, 5.1.5

LOCAL partitioning

spatial index, 4.1.7

LOCATE_PT function, 14

Locator, C

LRS

See Linear Referencing System (LRS)

LRS point, 6.1.9

map projections, 5.4.6

MBR

SDO_AGGR_MBR aggregate function, 12

SDO_MAX_MBR_ORDINATE function, 11

SDO_MBR function, 11

SDO_MIN_MBR_ORDINATE function, 11

MDSYS schema, 1.1

MDSYS user

created during default installation, A.2

protecting against unauthorized use, A.2

MDSYS.CS_SRS table, 5.4.1

MDSYS.SDO_ANGLE_UNITS table, 5.4.2

MDSYS.SDO_CS package, 13

MDSYS.SDO_DATUMS table, 5.4.4

MDSYS.SDO_DIST_UNITS table, 5.4.3

MDSYS.SDO_ELLIPSOIDS table, 5.4.5

MDSYS.SDO_PROJECTIONS table, 5.4.6

measure, 6.1.4

populating, 6.1.6

resetting, 14

reversing, 14

measure range, 6.1.7

MEASURE_RANGE function, 14

MEASURE_TO_PERCENTAGE function, 14

messages

Spatial error messages, 1.14

migration

instructions and issues, A

OGIS, 15, 15

procedures, 15

to current Spatial release, 15

to release 7.3.4, 15

See also upgrading

minimum bounding rectangle

AVERAGE_MBR procedure, 16

EXTENT_OF function, 16

SDO_AGGR_MBR aggregate function, 12

SDO_MAX_MBR_ORDINATE function, 11

SDO_MBR function, 11

SDO_MIN_MBR_ORDINATE function, 11

MIX_INFO procedure, 16

multipolygon, 2.3.2

nearest neighbor

SDO_NN operator, 10

non-geodetic index, 4.1.4

object types

embedding SDO_GEOMETRY objects in, 7.1, 7.2.2

object-relational model, 2

OCI (Oracle Call Interface) examples, 1.15

offset, 6.1.5

OFFSET_GEOM_SEGMENT function, 14

offsetting a geometric segment, 6.5.7

OGIS_METADATA_FROM procedure, 15

OGIS_METADATA_TO procedure, 15

ON mask relationship, 11

operators

cross-schema invocation, 4.2.3

SDO_FILTER, 10

SDO_NN, 10

SDO_NN_DISTANCE, 10

SDO_RELATE, 10

SDO_WITHIN_DISTANCE, 10

optimized rectangle, 2.2.4

Oracle Call Interface (OCI) examples, 1.15

OVERLAPBDYDISJOINT mask relationship, 11

OVERLAPBDYINTERSECT mask relationship, 11

parallel execution for index creation and rebuilding, 8, 8

partitioned spatial index, 4.1.7

exchanging partitions, 4.1.8

PERCENTAGE_TO_MEASURE function, 14

performance and tuning information, 1.11

PL/SQL and SQL examples, 1.15

point

data, 1.5.1

illustration and examples of point-only geometry, 2.3.5

locating on geometric segment, 6.5.8

LRS, 6.1.9

on surface of polygon, 11

shape, 6.1.2

polygon

area of, 11

centroid, 11

compound, 2.2.4

exterior and interior rings, 2.2.1, 2.2.4, 2.2.4, 2.3.2, 2.3.2

point on surface, 11

self-crossing not supported, 1.4

polygon collection, 2.3.2

polygon data, 1.5.1

populating

measure, 6.1.6

primary filter, 1.6, 4.2.1.1, 4.2.1.2

primitive types, 1.4

problems in current release, 5.7

geodetic data, 5.2.3

procedures

See functions and procedures

PROJECT_PT function, 14

projected coordinates, 1.5.4, 5.1.4

projection, 6.1.8

point onto geometric segment, 6.5.9

PROJECT_PT function, 14

projections, 5.4.6

quadtree indexes, 1.7.2

quality

degradation of R-tree index, 16

R-tree, 1.7.1.1

QUALITY_DEGRADATION function, 16

query, 4.2.1

query model for Spatial, 1.6

QUERY REWRITE

privilege and session requirements, 7.2

query window, 4.2.1

querying geometric segments

functions for, 14

range

measure, 6.1.7

rectangle

minimum bounding, 16

type, 2.2.4

REDEFINE_GEOM_SEGMENT procedure, 14

redefining a geometric segment, 6.5.2

RELATE function, 11

release 9i

migrating to Oracle9i, 15

release number (Spatial)

retrieving, 1.12

RESET_MEASURE procedure, 14

restrictions in current release, 5.7

geodetic data, 5.2.3

REVERSE_GEOMETRY function, 14

REVERSE_MEASURE function, 14

ring

exterior and interior polygon, 2.2.4

extracting from a geometry, 17

rollback segment

R-tree index creation, 4.1.1

R-tree indexes, 1.7.1

analyzing quality, 16

before creating, 4.1.1, 4.1.1

quality degradation, 16

quality score, 16

sequence object, 2.5.3

R-tree quality, 1.7.1.1

RTREE_QUALITY function, 16

SCALE_GEOM_SEGMENT function, 14

scaling a geometric segment, 6.5.6

schema

creating index on table in another schema, 4.1.6

invoking operators on table in another schema, 4.2.3

SDO_AGGR_CENTROID aggregate function, 12

SDO_AGGR_CONVEXHULL aggregate function, 12

SDO_AGGR_LRS_CONCAT aggregate function, 12

SDO_AGGR_MBR aggregate function, 12

SDO_AGGR_UNION aggregate function, 12

SDO_ANGLE_UNITS table, 5.4.2

SDO_ARC_DENSIFY function, 11

SDO_AREA function, 11

SDO_AREA_UNITS table, 2.6

SDO_BUFFER function, 11

SDO_CENTROID function, 11

SDO_CODE, 2.5.2

SDO_CONVEXHULL function, 11

SDO_CS package, 13

SDO_DATUMS table, 5.4.4

SDO_DIFFERENCE function, 11

SDO_DIST_UNITS table, 2.6, 5.4.3

SDO_DISTANCE function, 11

SDO_ELEM_INFO, 2.2.4

SDO_ELEM_INFO_ARRAY type, 2.2

SDO_ELLIPSOIDS table, 5.4.5

SDO_ETYPE, 2.2.4

SDO_FILTER operator, 10

SDO_GEOMETRY object type, 2.2

embedding in user-defined type, 7.1, 7.2.2

in function-based indexes, 7.2

methods, 9, 12

SDO_GROUPCODE, 2.5.2

SDO_GTYPE, 2.2.1

constraining data to a geometry type, 4.1.5

GET_DIMS method, 9

GET_GTYPE method, 9

GET_LRS_DIM method, 9

SDO_INDEX_TABLE, 2.5.2

SDO_INDX_DIMS keyword, 6.3

SDO_INTERPRETATION, 2.2.4

SDO_INTERSECTION function, 11

SDO_LENGTH function, 11

SDO_LEVEL, 1.7.2

SDO_MAX_MBR_ORDINATE function, 11

SDO_MBR function, 11

SDO_MIN_MBR_ORDINATE function, 11

SDO_NN operator, 10

optimizer hint, 10

SDO_NN_DISTANCE ancillary operator, 10

SDO_NUMTILES, 1.7.2

SDO_ORDINATE_ARRAY type, 2.2

SDO_ORDINATES, 2.2.5

SDO_POINT, 2.2.3

SDO_POINT_TYPE object type, 2.2

SDO_POINTONSURFACE function, 11

SDO_POLY_xxx functions (deprecated and removed), 11

SDO_PROJECTIONS table, 5.4.6

SDO_RELATE operator, 10

SDO_ROWID, 2.5.2

SDO_RTREE_SEQ_NAME, 2.5.3

SDO_SRID, 2.2.2

SDO_STARTING_OFFSET, 2.2.4

SDO_STATUS, 2.5.2

SDO_UNION function, 11

SDO_UNIT column

in SDO_AREA_UNITS table, 2.6

in SDO_DIST_UNITS table, 2.6, 5.4.3

SDO_VERSION function, 1.12

SDO_WITHIN_DISTANCE operator, 10

SDO_XOR function, 11

SDOAGGRTYPE object type, 1.9.1

secondary filter, 1.6, 4.2.1.2

segments

geometric, 6.1.1

self-crossing line strings and polygons, 1.4

semi-major axis, 5.4.5

sequence object for R-tree index, 2.5.3

SET_PT_MEASURE procedure, 14

shape point, 6.1.2

simple element, 2.2.4

size requirements (hardware) for spatial applications, 1.13

SORT_AREA_SIZE parameter

R-tree index creation, 4.1.1

spatial aggregate functions

See aggregate functions

spatial data structures

object-relational model, 2

spatial data types, 2

spatial index

See index

Spatial Index Advisor

using to determine best tiling level, 4.1.3

spatial indexing

fixed, 1.7.2.2

spatial join, 4.2.2

spatial query, 4.2.1

spatial reference systems

conceptual and usage information, 5

example, 5.8

function reference information, 13

sphere

authalic, 5.1.7

spheroids (ellipsoids), 5.4.5

SPLIT_GEOM_SEGMENT procedure, 14

splitting a geometric segment, 6.5.4

SQL and PL/SQL examples, 1.15

SQL*Loader, 3.1

SRID

0 (zero) special case with SDO_CS.VIEWPORT_TRANSFORM function, 13

in USER_SDO_GEOM_METADATA, 2.4.4

SDO_SRID in SDO_GEOMETRY, 2.2.2

synchronizing deferred index updates, 8

table name

restrictions on spatial table names, 2.4.1

TABLE_NAME (in USER_SDO_GEOM_METADATA), 2.4.1

tessellation, 1.7.2.1

three-dimensional (3D)

formats of LRS functions, 6.4

tile, 1.7.2, 4.2.1

tiling level

estimating, 16

TO_734 procedure, 15

TO_81x procedure, 15

TO_CURRENT procedure, 15

tolerance, 1.5.5

TOUCH mask relationship, 11

transactional insertion of spatial data, 3.2

TRANSFORM, 13

TRANSFORM_LAYER, 13

table for transformed layer, 13

transformation, 5.1.8

TRANSLATE_MEASURE procedure, 14

tuning and performance information, 1.11

tuning functions and procedures, 16

two-tier query, 1.6

type zero (0) element, 2.3.6

union, 11

unit of measurement

MDSYS tables, 2.6

UNIT_NAME column

in SDO_ANGLE_UNITS table, 5.4.2

in SDO_AREA_UNITS table, 2.6

in SDO_DIST_UNITS table, 2.6

UNIT_NAME column in SDO_DIST_UNITS table, 5.4.3

upgrading

from Spatial release 8.1.5, 8.1.6, or 8.7.1, A.3

from Spatial release 9.0.1, A.4

instructions and issues, A

LRS data, A.5

See also migration

USER_SDO_GEOM_METADATA view, 2.4

USER_SDO_INDEX_INFO view, 2.5.1.1

USER_SDO_INDEX_METADATA view, 2.5.1.2

user-defined coordinate system, 5.5

user-defined data types

embedding SDO_GEOMETRY objects in, 7.1, 7.2.2

utility functions, 17

VALID_GEOM_SEGMENT function, 14

VALID_LRS_POINT function, 14

VALID_MEASURE function, 14

VALIDATE_GEOMETRY function, 11

VALIDATE_GEOMETRY_WITH_CONTEXT function, 11

VALIDATE_LAYER procedure, 11

VALIDATE_LAYER_WITH_CONTEXT procedure, 11

VALIDATE_LRS_GEOMETRY function, 14

version number (Spatial)

retrieving, 1.12

VERTEX_SET_TYPE data type, 17

VERTEX_TYPE object type, 17

vertices

returning geometry coordinates as, 17

VIEWPORT_TRANSFORM, 13

well-known text (WKTEXT), 5.4.1.1

WITHIN_DISTANCE function, 11

WKTEXT column of MDSYS.CS_SRS table, 5.4.1.1

XOR

SDO_XOR function, 11

zero

SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 13

type 0 element, 2.3.6

Index

Numerics

A

B

C

D

E

F

G

H

I

L

M

N

O

P

Q

R

S

T

U

V

W

X

Z