怎么修改数据库表中geometry对象多边形其中一个点的坐标,即sdo_ordinates可变数组里的值,谢谢
例如:
数据库中存在表teststair,包含两个字段ID number, GEOM geometry;select * from teststair;
ID GEOM(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
1 SDO_GEOMETRY(3003, 262150, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(1296104.3 2, 137349.171, 0, 1296104.32, 136349.171, 0, 1297704.32, 136349.171, 0, 1297704.32, 137349.171, 0, 1296104.32, 137349.171, 0)) 2 SDO_GEOMETRY(3003, 262150, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(1296104.32, 137549.171, 0, 1296104.32, 138549.171, 0, 1297704.32, 138549.171, 0, 1297704.32, 137549.171, 0, 1296104.32, 137549.171, 0, 1296104.32, 137549.171, 0)) 3 SDO_GEOMETRY(3003, 262150, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(1280104.32, 141149.171, 0, 1280104.32, 142149.171, 0, 1282004.32, 142149.171, 0, 1282004.32, 141149.171, 0, 1280104.32, 141149.171, 0, 1280104.32, 141149.171, 0)) 现在需要将ID=1的行的GEOM多边形对象第一个点的Z轴坐标从0改为1,请问怎么做?我写了修改更新代码,不对,请各位高手支招,谢谢呵呵update teststair
set geom.sdo_geometry.sdo_ordinates(3)=1.000
where id=1;
提示没有等号,请问怎么设置是正确的?谢谢,急着了,呵呵。盼回复。
例如:
数据库中存在表teststair,包含两个字段ID number, GEOM geometry;select * from teststair;
ID GEOM(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
1 SDO_GEOMETRY(3003, 262150, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(1296104.3 2, 137349.171, 0, 1296104.32, 136349.171, 0, 1297704.32, 136349.171, 0, 1297704.32, 137349.171, 0, 1296104.32, 137349.171, 0)) 2 SDO_GEOMETRY(3003, 262150, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(1296104.32, 137549.171, 0, 1296104.32, 138549.171, 0, 1297704.32, 138549.171, 0, 1297704.32, 137549.171, 0, 1296104.32, 137549.171, 0, 1296104.32, 137549.171, 0)) 3 SDO_GEOMETRY(3003, 262150, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(1280104.32, 141149.171, 0, 1280104.32, 142149.171, 0, 1282004.32, 142149.171, 0, 1282004.32, 141149.171, 0, 1280104.32, 141149.171, 0, 1280104.32, 141149.171, 0)) 现在需要将ID=1的行的GEOM多边形对象第一个点的Z轴坐标从0改为1,请问怎么做?我写了修改更新代码,不对,请各位高手支招,谢谢呵呵update teststair
set geom.sdo_geometry.sdo_ordinates(3)=1.000
where id=1;
提示没有等号,请问怎么设置是正确的?谢谢,急着了,呵呵。盼回复。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货