Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm new to Oracle Spatial. In MySQL or PostGIS, it's easy to get minx miny maxx maxy of a geometry, any and/or all of them. But how to do that in Oracle Spatial?

Do I need to chain up several functions and properties to get any of them? Well this doesn't make sense to me.

Thanks in advance.

share|improve this question
up vote 4 down vote accepted

There are various functions you can use to get the minimum bounding rectangle in Oracle Spatial:


There are lots of examples here:

in section 2, which hopefully will help. It depends a bit what you're trying to get as to which one you would use. I generally end up using SDO_GEOM.SDO_MBR most of the time but you do usually end up with a few functions chained together as you say.

share|improve this answer
Thanks! However, it's a bit frustrated to hear that chaining up is the only solution. – Jackey Cheung Oct 17 '12 at 9:58

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.