Home » Server Options » Spatial » migrating from Informix to Oracle
migrating from Informix to Oracle [message #120948] Tue, 24 May 2005 23:49 Go to next message
acoli79
Messages: 1
Registered: May 2005
Junior Member
We are trying to migrate our Informix Spatial datablade specific queries
onto Oracle Spatial.
The queries are using informix blade's inbuilt functions like
SE_NEAREST, SE_POLYFROMSHAPE.
Where can we find the equivalent Oracle functions for these.
Re: migrating from Informix to Oracle [message #121102 is a reply to message #120948] Thu, 26 May 2005 01:54 Go to previous message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
Hi,

SE_NEAREST - Use the SDO_NN (Return Nearest Neighbors) or SDO_WITHIN_DISTANCE operators.

SE_POLYFROMSHAPE - not sure, try SDO_MBR (minimum bounding rectangle around a geometry object) or SDO_CONVEXHULL (convex polygon around the input geometry).

For more info, see the Oracle Spatial User's Guide and Reference.

Best regards.

Frank
Previous Topic: Discuss the componet of Oracle "Oracle Spatial "
Next Topic: interface not supported without a spatial index
Goto Forum:
  


Current Time: Mon Dec 29 07:08:40 CST 2014

Total time taken to generate the page: 0.04962 seconds