O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding materialized views

A view in the database presents a logical view of a table that is different from the actual physical structure of the table. We have used different views in our sample schema to make subsets of rows from the CITY_FURNITURE table look like tables. A view can also be defined on the result set of a query between two or more tables, for example, we can define a view to look at all the LAND_PARCELS that are affected by the maintenance work done to a sidewalk. For this, we define the view land_parcel_sidewalk as follows:

Create View land_parcel_sidewalk As Select a.fid lp_fid, b.fid sw_fid From land_parcels a, sidewalks b Where sdo_anyinteract(a.geom, b.geom) = 'TRUE'; -- lets find the land_parcels affected by a sidewalk ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required