ArcGIS Server Banner

ST_MPointFromText

ST_MPointFromText

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

NOTE: Spatial type for Oracle only

Definition

ST_MPointFromText creates an ST_Multipoint from a well-known text (WKT) representation of type ST_MultiPoint and a spatial reference ID.

Syntax

sde.st_mpointfromtext (wkt clob, srid integer)

Return type

ST_MultiPoint

Example

The multipoint_test table is created with the single ST_MultiPoint mpt1 column.

CREATE TABLE multipoint_test (mpt1 sde.st_geometry);

The INSERT statement inserts a multipoint into the mpt1 column using the ST_MPointFromText function.

INSERT INTO multipoint_test VALUES (
sde.st_mpointfromtext ('multipoint (10.01 20.03, 10.52 40.11, 30.29 41.56,
31.78 10.74)', 0));

See Also

  • An overview of SQL functions used with ST_Geometry types