7.100 SDO_GEOR.hasNODATAMask
Format
SDO_GEOR.hasNODATAMask( georaster IN SDO_GEORASTER, layerNumber IN NUMBER ) RETURN VARCHAR2;
Description
Checks if a GeoRaster object or layer has an associated NODATA bitmap mask.
Parameters
Usage Notes
This function returns the string TRUE
if the GeoRaster object or layer has an associated NODATA bitmap mask, or FALSE
if it does not have an associated NODATA bitmap mask.
For an explanation of bitmap masks, see Bitmap Masks.
Examples
The following example checks if layers 0 through 4 of a specified GeoRaster object have associated NODATA bitmap masks.
SELECT substr(sdo_geor.hasNODATAMask(georaster,0),1,12) BM0, substr(sdo_geor.hasNODATAMask(georaster,1),1,12) BM1, substr(sdo_geor.hasNODATAMask(georaster,2),1,12) BM2, substr(sdo_geor.hasNODATAMask(georaster,3),1,12) BM3 FROM georaster_table WHERE georid=0;
Parent topic: SDO_GEOR Package Reference