7.149 SDO_GEOR.setSpectralUnit
Format
SDO_GEOR.setSpectralUnit( georaster IN OUT SDO_GEORASTER, unit IN VARCHAR2);
Description
Sets the unit of measurement for identifying the wavelength interval for a band, or deletes the existing value if you specify a null unit
parameter.
Parameters
Usage Notes
Taken together, the spectral unit and spectral resolution identify the wavelength interval for a band. For example, if the spectral resolution value is 2 and the spectral unit value is MILLIMETER
, the wavelength interval for a band is 2 millimeters.
The GeoRaster object is automatically validated after the operation completes.
To return the spectral unit for a GeoRaster object, use the SDO_GEOR.getSpectralUnit function.
Examples
The following example sets MICROMETER
as the spectral unit for the GeoRaster object (GEORASTER column) in the row with the GEORID column value of 4 in the GEORASTER_TABLE table. (The GEORASTER_TABLE table definition is presented after Example 1-1 in Storage Parameters.)
DECLARE grobj sdo_georaster; BEGIN SELECT georaster INTO grobj FROM georaster_table WHERE georid=4 FOR UPDATE; sdo_geor.setSpectralUnit(grobj, 'micrometer'); UPDATE georaster_table SET georaster = grobj WHERE georid=4; COMMIT; END; /
Parent topic: SDO_GEOR Package Reference