Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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!
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 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!
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 Go to previous 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
Report message to a moderator
Previous Topic:query only ONE SDO_ORDINATE
Next Topic:how to run mapviewer??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 03:54:14 CDT 2008

Total time taken to generate the page: 0.05976 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.