发布时间 : 星期二 文章空间数据库实习三个实验更新完毕开始阅读
SDO_ORDINATE_ARRAY(5,1, 8,1, 8,6, 5,7, 5,1) ) );
INSERT INTO liufei VALUES( 3, 'cola_c', SDO_GEOMETRY(
2003, --two-dimensional polygon NULL, NULL,
SDO_ELEM_INFO_ARRAY(1,1003,1), --one polygon ring)
SDO_ORDINATE_ARRAY(3,3, 6,3, 6,5, 4,5, 3,3) ) );
INSERT INTO liufei VALUES( 4, 'cola_d', SDO_GEOMETRY(
2003, --two-dimensional polygon NULL, NULL,
SDO_ELEM_INFO_ARRAY(1,1003,4), --one circle SDO_ORDINATE_ARRAY(8,7, 10,9, 8,11) ) );
polygon (exterior
3．通过USER_SDO_GEOM_METADATA视图将COLA_MARKETS的空间属性列加入到空间元数据表中；
INSERT INTO USER_SDO_GEOM_METADATA VALUES ( 'liufei', 'shape',
SDO_DIM_ARRAY( --20X20 grid
SDO_DIM_ELEMENT('X', 0, 20, 0.005), SDO_DIM_ELEMENT('Y', 0, 20, 0.005) ),
NULL --SRID );
4.创建COLA_MARKETS表的空间索引COLA_SPATIAL_IDX； CREATE INDEX liufei_spatial_idx ON liufei (shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;
5.完成下列查询：
（1）查询cola_a和cola_c相交的部分；
SELECT SDO_GEOM.SDO_INTERSECTION(c_a.shape, c_c.shape, 0.005) FROM liufei c_a, liufei c_c
WHERE c_a.name= 'cola_a' AND c_c.name= 'cola_c';