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
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
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: 4426
Registered: April 1998
Senior Member

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.

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

Current Time: Wed Nov 25 07:07:30 CST 2015

Total time taken to generate the page: 0.07812 seconds