FME_SQL_DELIMITER !声明问号码;开始希利CT COUNT(*) INTO cnt FROM ALL_TABLES WHERE TABLE_NAME = 'CITY_PARKS' AND OWNER = 'SUPPORT';IF ( cnt > 0 ) THEN EXECUTE IMMEDIATE 'DROP TABLE CITY_PARKS';EXECUTE IMMEDIATE 'DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME=''CITY_PARKS'' ';END IF;END;!CREATE TABLE "SUPPORT"."CITY_PARKS" ("PARKID" NUMBER(*,0), "REFPARKID" NUMBER(*,0), "PARKNAME" VARCHAR2(40 BYTE), "NEIGHBORHOODNAME" VARCHAR2(40 BYTE), "EWSTREET" VARCHAR2(30 BYTE), "NSSTREET" VARCHAR2(30 BYTE), "DOGPARK" VARCHAR2(1 BYTE), "WASHROOMS" VARCHAR2(1 BYTE), "SPECIALFEATURES" VARCHAR2(1 BYTE), "POINTS" SDO_GEOMETRY, "POLYGONS" SDO_GEOMETRY )!INSERT into USER_SDO_GEOM_METADATA (table_name,column_name,diminfo,srid) VALUES ('CITY_PARKS','POINTS', sdo_dim_array(sdo_dim_element('X',3000000,10000000,0.005),sdo_dim_element('Y',3200000,10100000,0.005)), 2277)!INSERT into USER_SDO_GEOM_METADATA (table_name,column_name,diminfo,srid) VALUES ('CITY_PARKS','POLYGONS', sdo_dim_array(sdo_dim_element('X',3000000,10000000,0.005),sdo_dim_element('Y',3200000,10100000,0.005)), 2277)!