Skip to content

Instantly share code, notes, and snippets.

@vmleon

vmleon/spatial_warehouse_branches_alter_example.sql

Last active January 14, 2021 16:29
Show Gist options
  • Save vmleon/8e5fd50ca04cb5778e54e2989e7fa982 to your computer and use it in GitHub Desktop.
Save vmleon/8e5fd50ca04cb5778e54e2989e7fa982 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Spatial Example: Warehouses and Branches, alter statements
Raw
spatial_warehouse_branches_alter_example.sql
ALTER TABLE WAREHOUSES ADD (GEOMETRY SDO_GEOMETRY);
ALTER TABLE BRANCHES ADD (GEOMETRY SDO_GEOMETRY);
UPDATE WAREHOUSES SET
GEOMETRY = SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE(LON, LAT, NULL), NULL, NULL);
UPDATE BRANCHES SET
GEOMETRY = SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE(LON, LAT, NULL), NULL, NULL);
@vmleon
Copy link
Author

vmleon commented Jan 14, 2021

Add compact formatting

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment