Home » Server Options » Spatial » Querying only SDO_ORDINATES information from SDO_GEOMETRY Object
Querying only SDO_ORDINATES information from SDO_GEOMETRY Object [message #144339] Wed, 26 October 2005 01:52 Go to next message
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!
Re: Querying only SDO_ORDINATES information from SDO_GEOMETRY Object [message #145971 is a reply to message #144339] Mon, 07 November 2005 22:02 Go to previous messageGo to next message
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!
Re: Querying only SDO_ORDINATES information from SDO_GEOMETRY Object [message #207610 is a reply to message #144339] Wed, 06 December 2006 03:47 Go to previous messageGo to next message
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
Re: Querying only SDO_ORDINATES information from SDO_GEOMETRY Object [message #437091 is a reply to message #207610] Thu, 31 December 2009 00:51 Go to previous message
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.
Previous Topic: Rubber Sheeting
Next Topic: ORA-0939: too many arguments for function
Goto Forum:
  


Current Time: Thu Mar 28 17:02:02 CDT 2024