Can I create an Oracle Spatial View from a non-spatial table?

المشرف العام

Administrator
طاقم الإدارة
Let's say I have an Oracle database table with latitudes and longitudes. I don't have access to modify the schema of this table, or even create tables. However, I can create views and indexes on those views. I purpose the following problem:

Can I create a view that takes in two fields, and creates an SDO_GEOMETRY (point in this case) "on the fly", or does the field have to be based upon an already existing column?



أكثر...
 
أعلى