OraFAQ Forum: Spatial » query only ONE SDO

Home » Server Options » Spatial » query only ONE SDO_ORDINATE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

query only ONE SDO_ORDINATE [message #207609]

Wed, 06 December 2006 03:43

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

FIRAS

[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

swapnabpnn
Messages: 96
Registered: December 2010

Member

Hi,
you can use the following query

Code: [Select all] [Show/ hide]

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

This might help you out....

Report message to a moderator

Previous Topic:	Update query
Next Topic:	query to find first value of array (3 threads merged by bb)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 07:20:12 CDT 2025