[Qgis-user] Detecting Geometry Type For Oracle Object

Simon Greener simon at spatialdbadvisor.com
Sun Jan 29 21:42:22 PST 2017


QGIS, when querying Oracle to determine the geometry type in a table's
sdo_geometry column executes the following SQL:

SELECT DISTINCT gtype FROM (SELECT t."GEOMETRY".sdo_gtype AS gtype FROM
"<XXXX>"."<TABLENAME>" t WHERE t."GEOMETRY" IS NOT NULL AND rownum<1000)
WHERE rownum<=2

If there any way that I can force QGIS to change the number it samples?

regards
Simon




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Detecting-Geometry-Type-For-Oracle-Object-tp5305257.html
Sent from the QGIS - User mailing list archive at Nabble.com.



More information about the Qgis-user mailing list