7.104 SDO_GEOR.isBlank
Format
SDO_GEOR.isBlank( georaster IN SDO_GEORASTER ) RETURN VARCHAR2;
Description
Returns the string TRUE
if the GeoRaster object is a blank GeoRaster object, or FALSE
if the GeoRaster object is not a blank GeoRaster object.
Usage Notes
In a blank GeoRaster object, all cells have the same cell value.
To change the cell value of an existing blank GeoRaster object, use the SDO_GEOR.setBlankCellValue procedure. To return the cell value of a specified GeoRaster object, use the SDO_GEOR.getBlankCellValue function.
Examples
The following example determines whether or not each GeoRaster object in the GEORASTER column of the GEORASTER_TABLE table is a blank GeoRaster object. (The GEORASTER_TABLE table definition is presented after Example 1-1 in Storage Parameters.)
SELECT georid, substr(sdo_geor.isBlank(georaster),1,7) isBlank FROM georaster_table; GEORID ISBLANK ---------- ------- 2 FALSE 4 FALSE
Parent topic: SDO_GEOR Package Reference