FAQ: Can a query layer be created from an Oracle Spatial table, containing multiple geometry columns?
Can a query layer be created from an Oracle Spatial table, containing multiple geometry columns?
Yes, a query layer can be created by specifying any one of the spatial columns in the SELECT list of the query.
Since ArcGIS supports only one spatial column in a layer, a Query Layer can be used to work with database tables that have multiple spatial fields.
While building the query, only one spatial column is allowed in the SELECT list of the query, however other spatial columns can still be used in a WHERE clause of the query to spatially join with other tables in the database.
Alternatively, database views of the same table with one spatial column can also be registered with ArcSDE using 'sdelayer -o register' command to create layers from a table having multiple geometry columns. However, ArcSDE installation is required for using the sdelayer command.
• What is a query layer?
• Connecting to a database
• Creating a query layer
• Working with a query layer in ArcMap
- Example: Creating a spatial view in Oracle using SQL and registering it
- Example: Creating a database view in Oracle using the sdetable command