— Return the topological intersection of two geometries. SELECT SDO_GEOM.SDO_INTERSECTION(c_a.shape, c_c.shape, 0.005) FROM cola_markets c_a, cola_markets c_c WHERE c_a.name =‘cola_a‘AND c_c.name =‘cola_c‘; — Do two geometries have any spatial relationship? SELECT SDO_GEOM.RELATE(c_b.shape, ‘anyinteract‘, c_d.shape, 0.005) FROM cola_markets c_b, cola_markets c_d WHERE c_b.name =‘cola_b‘AND c_d.name =‘cola_d‘; — Return the areas of all cola markets. SELECT name, SDO_GEOM.SDO_AREA(shape, 0.005) FROM cola_markets; — Return the area of just cola_a. SELECT c.name, SDO_GEOM.SDO_AREA(c.shape, 0.005) FROM cola_markets c WHERE c.name =‘cola_a‘; — Return the distance between two geometries. SELECT SDO_GEOM.SDO_DISTANCE(c_b.shape, c_d.shape, 0.005) FROM cola_markets c_b, cola_markets c_d WHERE c_b.name =‘cola_b‘AND c_d.name =‘cola_d‘; — Is a geometry valid? SELECT c.name, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(c.shape, 0.005) FROM cola_markets c WHERE c.name =‘cola_c‘; — Is a layer valid? (First, create the results table.) CREATETABLE val_results (sdo_rowid ROWID, result VARCHAR2(2000)); CALL SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT(‘COLA_MARKETS‘, ‘SHAPE‘, ‘VAL_RESULTS‘, 2); SELECT*from val_results;