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_POINT

Object Details

Object Name:	ST_POINT
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
ST_POINT	SELF(ST_POINT) XCOORD(DOUBLE PRECISION) YCOORD(DOUBLE PRECISION)	ST_POINT
ST_POINT	SELF(ST_POINT) XCOORD(DOUBLE PRECISION) YCOORD(DOUBLE PRECISION) ASRID(INTEGER)	ST_POINT
ST_DIMENSION	SELF(ST_POINT)	INTEGER
ST_X	SELF(ST_POINT)	DOUBLE PRECISION
ST_X	SELF(ST_POINT) XCOORD(DOUBLE PRECISION)	ST_POINT
ST_Y	SELF(ST_POINT)	DOUBLE PRECISION
ST_Y	SELF(ST_POINT) YCOORD(DOUBLE PRECISION)	ST_POINT
ST_EXPLICITPOINT	SELF(ST_POINT)	ST_DOUBLE_PRECISION_ARRAY

Dependencies

[top of page]

MDSYS.ST_POINT references the following:

MDSYS: SDO_GEOMETRY; ST_DOUBLE_PRECISION_ARRAY; ST_GEOMETRY
SYS: STANDARD - show dependent code

MDSYS.ST_POINT is referenced by following:

MDSYS: OGC_ENDPOINT; OGC_POINTFROMTEXT; OGC_POINTFROMWKB; OGC_POINTN; OGC_POINTONSURFACE; OGC_STARTPOINT; OGC_X; OGC_Y; ST_CIRCULARSTRING; ST_CURVE; ST_CURVE; ST_GEOMETRY; ST_LINESTRING; ST_MULTIPOINT; ST_MULTISURFACE; ST_MULTISURFACE; ST_POINT; ST_POINT_ARRAY; ST_SURFACE; ST_SURFACE
PUBLIC: POINT; ST_POINT