Re: Oracle Spataial - simple select

From: Christof Kaiser <Kaiser_at_logiball.de>
Date: Fri, 12 Apr 2002 10:08:49 +0200
Message-ID: <3CB69611.5C10F6C6@logiball.de>

you'l have to fiddle around with teh sdo_geometry object.

the sql function THE( ) makes a kind of a table out of an object (such as sdo:geoemtry).
so look up THE in the sql reference.

the statement will look a bit uggly in the end but it is possible. actually, it look sthat ugly that i dont feel like trying it right now.

regards
christof

CODI wrote:

> Table SD_POL includes field GEOM of type SDO_GEOMETRY with point
> coordinates.
> How can I get, with select statement, separately x and y coordinates from
> SDO_GEOMETRY field.
>
> Regards
> CODI
Received on Fri Apr 12 2002 - 03:08:49 CDT