Oracle Spatial Example: Warehouses and Branches, big query

spatial_warehouse_branches_big_query_example.sql

SELECT
    BRANCH_NAME,
    ROUND(SDO_NN_DISTANCE(1), 2) DISTANCE_KM
FROM
    BRANCHES    B,
    WAREHOUSES  W
WHERE W.WAREHOUSE_NAME = 'Odessa Warehouse'
    AND SDO_NN(B.GEOMETRY, W.GEOMETRY, 'sdo_num_res=5 unit=km', 1) = 'TRUE'
ORDER BY DISTANCE_KM;