eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TYPE: MDSYS.ST_GEOMETRY

Object Details

Object Name:	ST_GEOMETRY
Object Type:	TYPE
Owner:	MDSYS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
GEOM	SDO_GEOMETRY

Methods

Name	Parameters	Result
GET_SDO_GEOM	SELF(ST_GEOMETRY)	SDO_GEOMETRY
GET_WKB	SELF(ST_GEOMETRY)	BLOB
GET_WKT	SELF(ST_GEOMETRY)	CLOB
ST_COORDDIM	SELF(ST_GEOMETRY)	SMALLINT
ST_ISVALID	SELF(ST_GEOMETRY)	INTEGER
ST_SRID	SELF(ST_GEOMETRY)	INTEGER
ST_SRID	SELF(ST_GEOMETRY) ASRID(INTEGER)	ST_GEOMETRY
FROM_WKT	WKT(CLOB)	ST_GEOMETRY
FROM_WKT	WKT(VARCHAR2)	ST_GEOMETRY
FROM_WKB	WKB(BLOB)	ST_GEOMETRY
FROM_WKT	WKT(CLOB) ASRID(INTEGER)	ST_GEOMETRY
FROM_WKT	WKT(VARCHAR2) ASRID(INTEGER)	ST_GEOMETRY
FROM_WKB	WKB(BLOB) ASRID(INTEGER)	ST_GEOMETRY
FROM_SDO_GEOM	AGEOMETRY(SDO_GEOMETRY)	ST_GEOMETRY
ST_ISEMPTY	SELF(ST_GEOMETRY)	INTEGER
ST_ENVELOPE	SELF(ST_GEOMETRY)	ST_GEOMETRY
ST_BOUNDARY	SELF(ST_GEOMETRY)	ST_GEOMETRY
ST_GEOMETRYTYPE	SELF(ST_GEOMETRY)	VARCHAR2
ST_BUFFER	SELF(ST_GEOMETRY) D(NUMBER)	ST_GEOMETRY
ST_EQUALS	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_SYMMETRICDIFFERENCE	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	ST_GEOMETRY
ST_DISTANCE	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	NUMBER
ST_ISSIMPLE	SELF(ST_GEOMETRY)	INTEGER
ST_INTERSECTS	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_RELATE	SELF(ST_GEOMETRY) G2(ST_GEOMETRY) PATTERNMATRIX(VARCHAR2)	INTEGER
ST_DIMENSION	SELF(ST_GEOMETRY)	INTEGER
ST_CROSS	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_DISJOINT	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_TOUCH	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_WITHIN	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_OVERLAP	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_CONTAINS	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_INTERSECTION	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	ST_GEOMETRY
ST_DIFFERENCE	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	ST_GEOMETRY
ST_UNION	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	ST_GEOMETRY
ST_CONVEXHULL	SELF(ST_GEOMETRY)	ST_GEOMETRY
ST_CENTROID	SELF(ST_GEOMETRY)	ST_GEOMETRY
ST_SYMDIFFERENCE	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	ST_GEOMETRY
ST_TOUCHES	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_CROSSES	SELF(ST_GEOMETRY) G2(ST_GEOMETRY)	INTEGER
ST_GETTOLERANCE	SELF(ST_GEOMETRY)	NUMBER
ST_ASTEXT	AGEOMETRY(ST_GEOMETRY)	CLOB
ST_ASBINARY	AGEOMETRY(ST_GEOMETRY)	BLOB
ST_GEOMFROMTEXT	WKT(CLOB)	ST_GEOMETRY
ST_GEOMFROMWKB	WKB(BLOB)	ST_GEOMETRY
ST_GEOMFROMTEXT	WKT(CLOB) ASRID(INTEGER)	ST_GEOMETRY
ST_GEOMFROMWKB	WKB(BLOB) ASRID(INTEGER)	ST_GEOMETRY

Dependencies

[top of page]

MDSYS.ST_GEOMETRY references the following:

MDSYS: SDO_GEOMETRY
SYS: STANDARD - show dependent code

MDSYS.ST_GEOMETRY is referenced by following:

MDSYS: OGC_AREA; OGC_ASBINARY; OGC_ASTEXT; OGC_BOUNDARY; OGC_BUFFER; OGC_CENTROID; OGC_CONTAINS; OGC_CONVEXHULL; OGC_CROSS; OGC_DIFFERENCE; OGC_DIMENSION; OGC_DISJOINT; OGC_DISTANCE; OGC_ENVELOPE; OGC_EQUALS; OGC_GEOMETRYN; OGC_GEOMETRYTYPE; OGC_INTERSECTION; OGC_INTERSECTS; OGC_ISCLOSED; OGC_ISEMPTY; OGC_ISSIMPLE; OGC_LENGTH; OGC_LINESTRINGFROMTEXT; OGC_LINESTRINGFROMWKB; OGC_MULTILINESTRINGFROMTEXT; OGC_MULTILINESTRINGFROMWKB; OGC_MULTIPOLYGONFROMTEXT; OGC_MULTIPOLYGONFROMWKB; OGC_OVERLAP; OGC_POINTFROMTEXT; OGC_POINTFROMWKB; OGC_POINTONSURFACE; OGC_POLYGONFROMTEXT; OGC_POLYGONFROMWKB; OGC_RELATE; OGC_SRID; OGC_SYMMETRICDIFFERENCE; OGC_TOUCH; OGC_UNION; OGC_WITHIN; PRVT_IDX - show dependent code; PRVT_IDX - show dependent code; SDO_3GL - show dependent code; SDO_3GL - show dependent code; SDO_ANYINTERACT; SDO_CONTAINS; SDO_COVEREDBY; SDO_COVERS; SDO_EQUAL; SDO_FILTER; SDO_INDEX_METHOD_10I; SDO_INDEX_METHOD_10I; SDO_INSIDE; SDO_NN; SDO_NN_DISTANCE; SDO_ON; SDO_OVERLAPBDYDISJOINT; SDO_OVERLAPBDYINTERSECT; SDO_OVERLAPS; SDO_RELATE; SDO_STATISTICS; SDO_STATISTICS; SDO_TOUCH; SDO_WITHIN_DISTANCE; ST_CIRCULARSTRING; ST_COMPOUNDCURVE; ST_CURVE; ST_CURVE; ST_CURVEPOLYGON; ST_CURVEPOLYGON; ST_GEOMCOLLECTION; ST_GEOMCOLLECTION; ST_GEOMETRY; ST_GEOMETRY_ARRAY; ST_LINESTRING; ST_LINESTRING; ST_MULTICURVE; ST_MULTICURVE; ST_MULTILINESTRING; ST_MULTIPOINT; ST_MULTIPOINT; ST_MULTIPOLYGON; ST_MULTIPOLYGON; ST_MULTISURFACE; ST_MULTISURFACE; ST_POINT; ST_POLYGON; ST_POLYGON; ST_SURFACE; ST_SURFACE; ST_SURFACE_ARRAY
PUBLIC: GEOMETRY; ST_GEOMETRY