CODEWITHSUNDEEP
oracle-databasepolygonoracle-spatial
Kody
Kody

Reputation: 1254

Oracle spatial Polygons

I'm searching for an example/explanation how to save geographic references that describes polygons for Oracle Databases.

I've found out, that SDO_GEOMETRY seems to work for that case generally. How can I put multiple 'nodes' into SDO_GEOMETRY?

A little example would be great!

Upvotes: 2

Views: 422

Answers (1)

user2487736
user2487736

Reputation: 56

Example sql would be select sdo_geometry(2003, null, null, mdsys.sdo_elem_info_array(1, 1003, 3), mdsys.sdo_ordinate_array(671 ,672, 849 ,850)) from dual

Best place to start is "Pro Oracle Spatial for Oracle Database 11g" http://www.apress.com/9781590598993.

Upvotes: 4

Related Questions