Oracle坐标分析命令,执行基于ä½�置的分æž� |
您所在的位置:网站首页 › windows无法备份 › 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; |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |