Creating a Feature Based on Database Views Using Multiple Tables
To join multiple tables together to create a new feature, views are necessary. The view must have a primary key (disabled), an exposed geometry column, and be registered in the SDO Geometry metadata. To be able to update this type of view, triggers must be created.
In this example, one of the tables contains geometry and the other does not.