+7When working with Oracle Locator Spatial there are a lot of cases that require an alias on a table. This works really well in the "select" statement of the Oracle reader but it limits the update of column names unless the select clause is updated as well. It would be an awesome enhancement to add in an alias option to the where. The table name is not allowed unless you add the where as an alias.
i.e. in the where clause allow
a.shape.sdo_gtype = 4402
I agree, it would be useful if the generated SQL for reading Oracle tables always added a default, clearly documented, alias of something like "t". So you could then read in just line geometry types using "t.geometry.sdo_gtype=2002"
Note that we can currently workaround that using a WHERE clause such as:
"rowid in (select rowid from my_table t where t.geometry.sdo_gtype=2002)"
This makes good sense to me. The current workaround is to use something like SQLCreator to specify the whole select statement yourself.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
