5 实验1 oracle 10g的安装与使用-spatial实例.pptVIP

-- Is a layer valid? (First, create the results table.) CREATE TABLE validation_results (mkt_id number, result varchar2(10)); EXECUTE SDO_GEOM.VALIDATE_LAYER(COLA_MARKETS, SHAPE, MKT_ID,VALIDATION_RESULTS); SELECT * from validation_results; 5、Oracle 10g数据库管理 6、Oracle Spatial实例分析 Oracle Spatial实例分析 drop INDEX cola_spatial_idx; drop TABLE cola_markets; Delete from USER_SDO_GEOM_METADATA; CREATE TABLE cola_markets ( mkt_id NUMBER PRIMARY KEY, name VARCHAR2(32), shape MDSYS.SDO_GEOMETRY); INSERT INTO cola_markets VALUES( 1, cola_a, MDSYS.SDO_GEOMETRY( 2003, -- 2-dimensional polygon NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3), -- one rectangle (1003 = exterior) MDSYS.SDO_ORDINATE_ARRAY(1,1, 5,7) -- only 2 points needed to )); INSERT INTO cola_markets VALUES( 2, cola_b, MDSYS.SDO_GEOMETRY( 2003, -- 2-dimensional polygon NULL,NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), -- one polygon (exterior polygon ring) MDSYS.SDO_ORDINATE_ARRAY(5,1, 8,1, 8,6, 5,7, 5,1) )); INSERT INTO cola_markets VALUES( 3, cola_c, MDSYS.SDO_GEOMETRY( 2003, -- 2-dimensional polygon NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), -- one polygon (exterior polygon ring) MDSYS.SDO_ORDINATE_ARRAY(3,3, 6,3, 6,5, 4,5, 3,3) )); INSERT INTO cola_markets VALUES( 2, cola_b, MDSYS.SDO_GEOMETRY( 2003, -- 2-dimensional polygon NULL,NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), -- one polygon (exterior polygon ring) MDSYS.SDO_ORDINATE_ARRAY(5,1, 8,1, 8,6, 5,7, 5,1) )); INSERT INTO cola_markets VALUES( 3, cola_c, MDSYS.SDO_GEOMETRY( 2003, -- 2-dimensional polygon NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), -- one polygon (exterior polygon ring) MDSYS.SDO_ORDINATE_ARRAY(3,3, 6,3, 6,5, 4,5, 3,3) )); INSERT INTO cola_markets VALUES( 4, cola_d, MDSYS.SDO_GEOMETRY( 2003, -- 2-dimensional polygon NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,4), -- one circle MDSYS.SDO_ORDINATE_ARRAY(8,7, 10,9, 8,11) ) ); --更新原数据表 INSERT INTO USER_SDO_GEOM_METADATA VALUES ( cola_markets, shape,MDSYS.SDO_DIM_ARRAY( -- 20X