7.88 SDO_GEOR.getSpatialDimSizes
Format
SDO_GEOR.getSpatialDimSizes( georaster IN SDO_GEORASTER ) RETURN SDO_NUMBER_ARRAY;
Description
Returns the number of cells in each spatial dimension of a GeoRaster object.
Usage Notes
To return the number of spatial dimensions for a GeoRaster object, use the SDO_GEOR.getSpatialDimNumber function.
Examples
The following example returns the spatial dimension sizes and the number of bands for a GeoRaster object. (It refers to a table named GEORASTER_TABLE, whose definition is presented after Example 1-1 in Storage Parameters. The output is reformatted for readability.)
SELECT sdo_geor.getSpatialDimSizes(georaster) spatialDimSizes, sdo_geor.getBandDimSize(georaster) bandDimSize FROM georaster_table WHERE georid=21; SPATIALDIMSIZES BANDDIMSIZE -------------------------- ----------- SDO_NUMBER_ARRAY(512, 512) 1
Parent topic: SDO_GEOR Package Reference