SQL如何取得一个面的中心点

select sdo_geom.sdo_centroid(t.shape, 2) .sdo_point.x x,
sdo_geom.sdo_centroid(t.shape, 2) .sdo_point.y y from gd_zy_region t

 

SELECT MAX(SUBSTR(N.COOR, 2, LENGTH(N.COOR))) AS COOR
  FROM (select curr, SYS_CONNECT_BY_PATH(coor, ';') AS COOR, prev
          from (select rownum as curr,
                       m.COLUMN_VALUE as coor,
                       rownum - 1 as prev
                  from table (select t.SHAPE.sdo_ordinates as c
                                from dmgc_GX t
                               where t.OBJECTID = 11) m)
         start with curr = 1
        connect by prev = PRIOR curr) N

 

select replace(wm_concat(m.COLUMN_VALUE), ',', ';') as coor from table (select t.SHAPE.sdo_ordinates as c from " + strFileName + " t where t.OBJECTID = " + objectid + ") m

 

//存储过程 循环遍历将空间坐标转化为属性数据

create or replace procedure insertxy is
cursor var_ids is
select objectid var_objid from DM_ZK;
var_objid varchar2(35);
begin
for vc in var_ids loop
insert into DM_ZK_TEMP
(ZB)
select replace(wm_concat(m.COLUMN_VALUE), ',', ';') as coor
from table (select t.SHAPE.sdo_ordinates as c
from DM_ZK t
where t.OBJECTID = vc.var_objid) m;
end loop;
end insertxy;