在登录 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;