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