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

sde.st_mpointfromtext (wkt clob, srid integer)

ST_MultiPoint

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));