oracle 创建sdo_geometry 完整的sql语句

---创建表
create table  gis_rule_test (
 rule_id  number primary key,
 rule_name  varchar2(32),
 shape sdo_geometry
)

---插入元数据
insert into user_sdo_geom_metadata(TABLE_NAME,COLUMN_NAME,DIMINFO,SRID)
 values(
'gis_rule_test',
'shape',
 SDO_DIM_ARRAY(   -- 20X20 grid
    SDO_DIM_ELEMENT('X', -180, 180, 0.0000001),
    SDO_DIM_ELEMENT('Y', -90, 90, 0.0000001)
     ),
  4326   -- SRID

 )
 -- 创建索引
 CREATE INDEX gis_rule_test_idx ON gis_rule_test(shape)   
INDEXTYPE IS MDSYS.SPATIAL_INDEX 
 
 -- 插入多边形数据
 
 insert into gis_rule_test values(
 1,
 'china_rule1',
  sdo_geometry(
  2003,
  4326,
  null,
  sdo_elem_info_array(1,1003,1),
  sdo_ordinate_array(
  131,23,
  132,24,
  131.4,25,
  126,23,
  128,23
  )
  ))


 -- 查询空间数据
SELECT c.shape.ST_COORDDIM()
  FROM gis_rule_test c

附网上的文章：sdo_geometry 说明 http://blog.sina.com.cn/s/blog_9d0a434f0102wnt4.html