方式一(传入的是wkt):
INSERT INTO tablename
(id, GEOMETRY)
VALUES
(1,
SDO_GEOMETRY('LINESTRING (115.48883 36.59252, 115.4887 36.59164)', 8307));
方式二(直接传入坐标):
INSERT INTO tablename
(ID, GEOMETRY)
VALUES
(1,
SDO_GEOMETRY(2002,
8307,
NULL,
SDO_ELEM_INFO_ARRAY(1, 2, 1),
INSERT INTO tablename
(id, GEOMETRY)
VALUES
(1,
SDO_GEOMETRY('LINESTRING (115.48883 36.59252, 115.4887 36.59164)', 8307));
方式二(直接传入坐标):
INSERT INTO tablename
(ID, GEOMETRY)
VALUES
(1,
SDO_GEOMETRY(2002,
8307,
NULL,
SDO_ELEM_INFO_ARRAY(1, 2, 1),
SDO_ORDINATE_ARRAY(115.48883, 36.59252, 115.4887, 36.59164)));