Oracle坐标分析命令,执行基于ä½�置的分æž�

在登录 OE 模�的 SQL*Plus 会�中，�行以下脚本：

@wh_updates

该脚本包�以下语�：

REM script name: wh_updates.sql

REM Function-based indexes

REM adding wh_longitude/wh_latitude columns and populating them

REM

REM WAREHOUSES

REM

ALTER TABLE warehouses

DROP COLUMN wh_longitude;

ALTER TABLE warehouses

DROP COLUMN wh_latitude;

ALTER TABLE warehouses

ADD (wh_longitude number, wh_latitude number);

UPDATE warehouses

SET wh_longitude = -103.00195, wh_latitude = 36.500374

WHERE warehouse_id = 1;

UPDATE warehouses

SET wh_longitude = -124.21014, wh_latitude = 41.998016

WHERE warehouse_id = 2;

UPDATE warehouses

SET wh_longitude = -74.695305, wh_latitude = 41.35733

WHERE warehouse_id = 3;

UPDATE warehouses

SET wh_longitude = -123.61526, wh_latitude = 46.257458

WHERE warehouse_id = 4;

UPDATE warehouses

SET wh_longitude = -79.4167, wh_latitude = 43.6667

WHERE warehouse_id = 5;

UPDATE warehouses

SET wh_longitude = 151.2000, wh_latitude = -33.8833

WHERE warehouse_id = 6;

UPDATE warehouses

SET wh_longitude = -106.0500, wh_latitude = 24.3833

WHERE warehouse_id = 7;

UPDATE warehouses

SET wh_longitude = 123.8839, wh_latitude = 39.8667

WHERE warehouse_id = 8;

UPDATE warehouses

SET wh_longitude = 72.8333, wh_latitude = 18.9667

WHERE warehouse_id = 9;

COMMIT;