Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle Spatial: calculate areas and number of polygon points
Hello!
I've got Oracle 8i and I need a SQL statement for an Oracle Spatial Relational Model, which is able to calculate the area and the number of polygon points of each geometry object.
A result like this would be nice
SDO_GID Area NoPoints
1 144.34 6
Has anyone an idea how define a proper SQL statement to solve my task?
Thanks in advance,
Robert
Received on Mon Dec 02 2002 - 08:21:54 CST
![]() |
![]() |