7.34 SDO_GEOR.getBandDimSize
Format
SDO_GEOR.getBandDimSize( georaster IN SDO_GEORASTER ) RETURN NUMBER;
Description
Returns the number of bands in a GeoRaster object.
Usage Notes
For an explanation of bands, see Bands_ Layers_ and Metadata.
If georaster
or its metadata is null, this function returns a null value.
Examples
The following example returns the spatial dimension sizes and the number of bands (one in this case) 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