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...

FIRAS ]]>

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

This might help you out....

]]>