Can MapViewer display a theme based on a view?
Yes. When defining a theme that is based on a view, you will first need to register the view’s geometry column in user_sdo_geom_metadata. Use the view name as the table_name value when inserting into user_sdo_geom_metadata. If your view is a join view (based on more than one base tables), you must also manually modify the theme’s styling_rules to specify a key_column attribute. This attribute tells MapViewer the name of the column in the view that can serve as the id column for the geometries. By default, a predefined theme will use ROWID as the key column when caching/referencing geometries for that theme. With a join view however there is no ROWID.
