OraFAQ Forum: Spatial » Querying only SDO_ORDINATES information from SDO

Home » Server Options » Spatial » Querying only SDO_ORDINATES information from SDO_GEOMETRY Object

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

Querying only SDO_ORDINATES information from SDO_GEOMETRY Object [message #144339]

Wed, 26 October 2005 01:52

Adnany
Messages: 8
Registered: April 2005
Location: Malaysia

Junior Member

Hi All,

I want to query only the SDO_ORDINATE i.e(X,Y,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...

Adnan!

Report message to a moderator

Re: Querying only SDO_ORDINATES information from SDO_GEOMETRY Object [message #145971 is a reply to message #144339]

Mon, 07 November 2005 22:02

Adnany
Messages: 8
Registered: April 2005
Location: Malaysia

Junior Member

The following select lists all ordinate-values from ONE object in the table:

select *
from table(select a.<column_name>.sdo_ordinates
from <table_name> a
where ID = xxxx
)
/

You have to replace <column_name> and <table_name> accordingly.

(Solved by Anna)
Adnan!

Report message to a moderator

Re: Querying only SDO_ORDINATES information from SDO_GEOMETRY Object [message #207610 is a reply to message #144339]

Wed, 06 December 2006 03:47

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

Report message to a moderator

Re: Querying only SDO_ORDINATES information from SDO_GEOMETRY Object [message #437091 is a reply to message #207610]

Thu, 31 December 2009 00:51

nandus6
Messages: 2
Registered: December 2009
Location: Hyderabad

Junior Member

Hi Adnan,

I think You are looking for this

SELECT t.X,t.Y,t.Z FROM TableName Tb, TABLE(SDO_UTIL.GETVERTICES(Tb.GeometryColumnName )) t where Tb.ColumnName =xxxxx ORDER BY t.id;

You have to replace <ColumnName> , <TableName> and <GeometryColumnName> accordingly.

Thanks
Nandu.

Report message to a moderator

Previous Topic:	Rubber Sheeting
Next Topic:	ORA-0939: too many arguments for function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 05:26:07 CDT 2025