7.45 SDO_GEOR.getBlockSize
Format
SDO_GEOR.getBlockSize( georaster IN SDO_GEORASTER ) RETURN SDO_NUMBER_ARRAY;
Description
Returns the number of cells for each dimension in each block of a GeoRaster object in an array showing the number of cells for each row, column, and (if relevant) band.
Usage Notes
If georaster
or its metadata is null, or if georaster
is not blocked, this function returns a null value.
Examples
The following example returns the number of cells (512 in each dimension) in each block of the GeoRaster object (GEORASTER column) in the row with the GEORID column value of 21 in the GEORASTER_TABLE table, whose definition is presented after Example 1-1 in Storage Parameters.
SELECT sdo_geor.getBlockSize(georaster) blockSize FROM georaster_table WHERE georid=21; BLOCKSIZE -------------------------------------------------------------------------------- SDO_NUMBER_ARRAY(512, 512)
Parent topic: SDO_GEOR Package Reference