Geometry - Node - Vertex (plural vertices)

> Geometry (Spatial, Linear Algebra)

1 - About

Nodes of an object

Advertising

3 - Example

  • X,Y for two-dimensional objects

4 - Function

SELECT c.gid, t.X, t.Y, t.id
FROM HI_VERBLIJFSOBJECT c,
TABLE(SDO_UTIL.GETVERTICES(c.geometry)) t
ORDER BY c.gid, t.id;
GID	X	Y	ID
8	231675.128778746	583491.401516593	1
10	232767.789937693	581447.10954301	1
14	232767.789937693	581447.10954301	1