Oracle Spatial Example: Warehouses and Branches, insert statements

spatial_warehouse_branches_insert_example.sql

CREATE TABLE WAREHOUSES (WAREHOUSE_NAME VARCHAR2(30), LAT NUMBER, LON NUMBER);
CREATE TABLE BRANCHES (BRANCH_NAME VARCHAR2(30),ZIPCODE VARCHAR2(5), LAT NUMBER, LON NUMBER, BRANCH_TYPE VARCHAR2(30));
INSERT INTO WAREHOUSES VALUES ('Amarillo Warehouse',35.532226,-101.557617);
INSERT INTO WAREHOUSES VALUES ('Odessa Warehouse',31.334871,-102.062988);
INSERT INTO WAREHOUSES VALUES ('San Antonio Warehouse',29.496987,-98.833007);
INSERT INTO WAREHOUSES VALUES ('Waco Warehouse',31.27855,-97.097167);
INSERT INTO BRANCHES VALUES('Marshall Branch','75672',32.50555,-94.35579,'WHOLESALE');
INSERT INTO BRANCHES VALUES('Eagle Pass Branch','78852',28.6865,-100.47394,'RETAIL');
INSERT INTO BRANCHES VALUES('Cleburne Branch','76033',32.42166,-97.38356,'WHOLESALE');
INSERT INTO BRANCHES VALUES('Paris Branch','75460',33.66771,-95.5678,'RETAIL');
INSERT INTO BRANCHES VALUES('Boerne Branch','78006',29.80671,-98.70248,'RETAIL');
INSERT INTO BRANCHES VALUES('Temple Branch','76503',31.10109,-97.33947,'WHOLESALE');
INSERT INTO BRANCHES VALUES('Galvston Branch','77554',29.28626,-94.85884,'WHOLESALE');
INSERT INTO BRANCHES VALUES('Wharton Branch','77488',29.31394,-96.10216,'RETAIL');
INSERT INTO BRANCHES VALUES('Marble Falls Branch','78654',30.50005,-98.26728,'RETAIL');
INSERT INTO BRANCHES VALUES('Copperas Cove Branch','76522',31.10028,-97.89377,'RETAIL');
INSERT INTO BRANCHES VALUES('Bay City Branch','77414',28.99702,-95.9164,'WHOLESALE');
INSERT INTO BRANCHES VALUES('Del Rio Branch','78840',29.37022,-100.86395,'RETAIL');
                                                                                                                  
ALTER TABLE WAREHOUSES ADD (GEOMETRY SDO_GEOMETRY);
ALTER TABLE BRANCHES ADD (GEOMETRY SDO_GEOMETRY);