读取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 db

select db.SHAPE.SDO_gtype from T_table db