7.43 SDO_GEOR.getBlankCellValue
Format
SDO_GEOR.getBlankCellValue( georaster IN SDO_GEORASTER ) RETURN NUMBER;
Description
Returns the cell value for all cells if a specified GeoRaster object is a blank GeoRaster object.
Usage Notes
In a blank GeoRaster object, all cells have the same cell value. This function returns the cell value for all cells if the specified GeoRaster object is a blank GeoRaster object.
To set the cell value to be used if a specified GeoRaster object is a blank GeoRaster object, use the SDO_GEOR.setBlankCellValue procedure. To determine if a specified GeoRaster object is a blank GeoRaster object, use the SDO_GEOR.isBlank function.
If georaster
is null, invalid, or is not a blank GeoRaster object, the SDO_GEOR.getBlankCellValue function returns a null value.
Examples
The following example returns the blank cell values for all blank GeoRaster objects in the GEORASTER column of table GEORASTER_TABLE.
SELECT georid, sdo_geor.getBlankCellValue(georaster) blankValue FROM georaster_table WHERE sdo_geor.isBlank(georaster)='TRUE'; GEORID BLANKVALUE ---------- ---------- 1 255 2 155
Parent topic: SDO_GEOR Package Reference