ST_MultiPolygon constructs a multipolygon feature from a well-known text representation.
Oracle
sde.st_multipolygon (wkt clob, srid integer)
PostgreSQL
st_multipolygon (wkt, srid integer)
st_multipolygon (esri_shape bytea, srid integer)
Oracle
CREATE TABLE mpoly_test (id integer, geometry sde.st_geometry);
INSERT INTO mpoly_test VALUES (
1110,
sde.st_multipolygon ('multipolygon (((3 3, 4 6, 5 3, 3 3),(8 24, 9 25, 1 28, 8 24), (13 33, 7 36, 1 40, 10 43, 13 33)))', 0)
);
SELECT id, sde.st_astext (geometry) MULTI_POLYGON
FROM mpoly_test
WHERE id = 1110;
ID MULTI_POLYGON
1110 MULTIPOLYGON (((13.00000000 33.00000000, 10.00000000 43.00000000,
1.00000000 40.00000000, 7.00000000 36.00000000,
13.00000000 33.00000000)),((8.00000000 24.00000000, 9.00000000
25.00000000, 1.00000000 28.0000000, 8.00000000 24.00000000)),
((3.00000000 3.00000000, 5.00000000 3.00000000,
4.00000000 6.00000000, 3.00000000 3.00000000)))
PostgreSQL
CREATE TABLE mpoly_test (id integer, geometry st_geometry);
INSERT INTO mpoly_test VALUES (
1110,
st_multipolygon ('multipolygon (((3 3, 4 6, 5 3, 3 3), (8 24, 9 25, 1 28, 8 24), (13 33, 7 36, 1 40, 10 43, 13 33)))', 0)
);
SELECT id, st_astext (geometry) AS MULTI_POLYGON
FROM mpoly_test
WHERE id = 1110;
id multi_polygon
1110 MULTIPOLYGON (((13 33, 10 43, 1 40, 7 36, 13 33)),
((8 24, 9 25, 1 28, 8 24)), ((3 3, 5 3, 4 6, 6 6)))