Explanation : If a View is not visible in Geospatial Administrator while registering the feature. The reason is View does not have Primary Key or Unique Constraint on a column. OpenCities Map requires a primary key or unique constraint on view. However…

The following may be helpful to create an Oracle view that can be registered and queried as a spatial feature. The PARCELS has a number of columns: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production SQL> DESCRIBE PARCELS;…