Home » Server Options » Spatial » query only ONE SDO_ORDINATE
query only ONE SDO_ORDINATE [message #207609] Wed, 06 December 2006 03:43 Go to next message
Messages: 2
Registered: December 2006
Junior Member
Hi All,

I want to query only one the SDO_ORDINATE i.e(X or Y or Z (Coordinates Info)) information out of SDO_GEometry Object in Oracle 10g.

I tried this like Geometry.sdo_ordinates or geometry(sdo)ordinates but it didnt work.

So Can any one help me out in this problem that hows it is possible ?? Thanks in advance.

Waiting for your prompt replies...


[Updated on: Tue, 26 April 2011 04:24] by Moderator

Report message to a moderator

Re: query only ONE SDO_ORDINATE [message #504528 is a reply to message #207609] Tue, 26 April 2011 04:06 Go to previous message
Messages: 96
Registered: December 2010
you can use the following query

select a.geom.sdo_ordinates FROM cable a WHERE CABLE_ID = 1;

This might help you out....
Previous Topic: Update query
Next Topic: query to find first value of array (3 threads merged by bb)
Goto Forum:

Current Time: Sat May 08 18:37:40 CDT 2021