操作SDO_GEOMETRY字段

读取SDO_GEOMETRY字段

select  to_char(regexp_replace(sdo_util.to_gmlgeometry(t.intsxn_geom),‘</?[^>]*>|nbsp;|&‘,‘‘)) as ORDINATES from SALES_INTERSECTION_ZONES t

其中intsxn_geom是SDO_GEOMETRY类型字段，正则表达式的作用是去掉返回字符串中的<xxx>标记

写入SDO_GEOMETRY字段

INSERT INTO T_table (ID,SHAPE) VALUES(
          ‘10000000003‘,        
          MDSYS.SDO_GEOMETRY(
                      2003,
                      NULL,
                      NULL,
                      MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3,3,22),
                      MDSYS.SDO_ORDINATE_ARRAY(1,1, 5,7)

         )
);

 获取类型select db.shape.get_gtype() from T_table dbselect db.SHAPE.SDO_gtype from T_table db