bzplike的专栏

select address 地址, county 区, entertype 类型, round( sdo_geom.sdo_distance( sdo_geometry(2001,null,sdo_point_type(t_x,t_y,null),null,null), sdo_geometry(2001,null,sdo_point_type(t1_x,t1_y,null),null,nu

/*删除重复的数据*/ delete from T_GIS_LNGLATLOG_SHANGHAI_BAI t1   where (t1.address)   in (select t.address         from T_GIS_LNGLATLOG_SHANGHAI_BAI t        -- where t.address is null         group by