In a previous article I showed how too many digits of precision for the ordinates of an sdo_geometry object – stored in its sdo_ordinate_array – has an effect on storage volume. In this article I will revisit the question of storage size while examining the effect that storage size has on performance (search and retrieval).Read More
The knowledgeable Bryan Hall made a post over on the Oracle Technology Network’s Oracle Spatial Forum reminding users of the “hidden” issues that inform the way Oracle compare’s two geometries when using a secondary filter Here is the relevant section of the post. With relationship operators such as sdo_anyinteract that take two parameters for theRead More
This article shows how to apply Delaunay triangulation and inverse distance weighting (IDW) techniques for soils interpolation in Oracle.
A question was asked on the Oracle Technology Network Spatial forum: I am trying to select sdo_gtype from all tables in schema, i mean to execute same sql statement given below for entire schema. Any help on the usage of dynamic sql in PLSQL to execute select statement for all tables in the schema. HereRead More