7.69 SDO_GEOR.getInterleavingType
Format
SDO_GEOR.getInterleavingType( georaster IN SDO_GEORASTER ) RETURN VARCHAR2;
Description
Returns the interleaving type for a GeoRaster object.
Usage Notes
This function returns one of the following values: BSQ
(band sequential), BIL
(band interleaved by line), or BIP
(band interleaved by pixel).
To change the interleaving type for a GeoRaster object, use the SDO_GEOR.changeFormatCopy procedure, and use the interleaving
keyword in the storageParam
parameter string.
Examples
The following example returns the cell depth, interleaving type, and blocking type 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.getCellDepth(georaster) CellDepth, substr(sdo_geor.getInterleavingType(georaster),1,8) interleavingType, substr(sdo_geor.getBlockingType(georaster),1,8) blocking FROM georaster_table WHERE georid=21; CELLDEPTH INTERLEA BLOCKING ---------- -------- -------- 8 BSQ REGULAR
Parent topic: SDO_GEOR Package Reference