Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Introduction, 3 of 7


SDO_GEOM Package

Table 1-3 SDO_GEOM Package Subprograms  
Subprogram  Description 

RELATE 

Determines how two objects interact. 

SDO_ARC_DENSIFY 

Changes each circular arc into an approximation consisting of straight lines, and each circle into a polygon consisting of a series of straight lines that approximate the circle. 

SDO_AREA 

Computes the area of a two-dimensional polygon. 

SDO_BUFFER 

Generates a buffer polygon around a geometry. 

SDO_CENTROID 

Returns the centroid of a polygon.  

SDO_CONVEXHULL 

Returns a polygon-type object that represents the convex hull of a geometry object.  

SDO_DIFFERENCE 

Returns a geometry object that is the topological difference (MINUS operation) of two geometry objects.  

SDO_DISTANCE 

Computes the distance between two geometry objects.  

SDO_INTERSECTION 

Returns a geometry object that is the topological intersection (AND operation) of two geometry objects. 

SDO_LENGTH 

Computes the length or perimeter of a geometry. 

SDO_MAX_MBR_ORDINATE 

Returns the maximum value for the specified ordinate of the minimum bounding rectangle of a geometry object. 

SDO_MBR 

Returns the minimum bounding rectangle of a geometry. 

SDO_MIN_MBR_ORDINATE 

Returns the minimum value for the specified ordinate of the minimum bounding rectangle of a geometry object. 

SDO_POINTONSURFACE 

Returns a point that is guaranteed to be on the surface of a polygon.  

SDO_UNION 

Returns a geometry object that is the topological union (OR operation) of two geometry objects. 

SDO_XOR 

Returns a geometry object that is the topological symmetric difference (XOR operation) of two geometry objects. 

VALIDATE_GEOMETRY 

Determines if a geometry is valid. 

VALIDATE_LAYER 

Determines if all the geometries stored in a column are valid. 

WITHIN_DISTANCE 

Determines if two geometries are within a specified Euclidean distance from one another. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback