ST_MPointFromText

ST_Geometry in Oracle only
Definition
ST_MPointFromText takes a well-known text (WKT) representation of type ST_MultiPoint and a spatial reference ID and creates an ST_Multipoint.
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));
3/6/2012