Select aggregated Bounding Box of multiple Features using ArcSDE SQL

[G_L_]

I would like to calculate the aggregated bounding box of multiple features using OGC Simple Feature SQL or SQL API of ArcSDE. The following statement will only query the bounding box of each feature:

select ST_Boundary (shape) from polygon_table where country like '%usa%'

What I needed is one bounding box aggregated over all features, resulting to the condition in the where clause.

[VinceAngelo]

Update 2Puhh.. the patch is 4.6 GB in 7 files!! I leave it, and don't install it...

If you read the doc, you only need a fraction of that to update the database itself.
Given your reliance on Java, it's unwise to ignore Oracle updates, no matter how
large (most of the patches are Java-related).  You should really be keeping up with
the quarterly security patchset updates, too.

- V