| migrating from Informix to Oracle [message #120948] |
Tue, 24 May 2005 23:49  |
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  |
Frank Naude
Messages: 4587
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
