7.72 SDO_GEOR.getLayerID
Format
SDO_GEOR.getLayerID( georaster IN SDO_GEORASTER, layerNumber IN NUMBER ) RETURN VARCHAR2;
Description
Returns the user-defined identifier value associated with a layer in a GeoRaster object.
Parameters
Usage Notes
To set a user-defined identifier value for a layer in a GeoRaster object, use the SDO_GEOR.setLayerID procedure.
Examples
The following example returns the user-defined identifier values of layers 0, 1, 2, and 3 of the GeoRaster object (GEORASTER column) in the row with the GEORID column value of 4 in the GEORASTER_TABLE table, whose definition is presented after Example 1-1 in Storage Parameters.
SELECT substr(sdo_geor.getLayerID(georaster, 0),1,12) layerID0, substr(sdo_geor.getLayerID(georaster, 1),1,12) layerID1, substr(sdo_geor.getLayerID(georaster, 2),1,12) layerID2, substr(sdo_geor.getLayerID(georaster, 3),1,12) layerID3 FROM georaster_table WHERE georid=4; LAYERID0 LAYERID1 LAYERID2 LAYERID3 ------------ ------------ ------------ ------------ TM543 TM3 TM4 TM5
Parent topic: SDO_GEOR Package Reference