7.68 SDO_GEOR.getID
Format
SDO_GEOR.getID( georaster IN SDO_GEORASTER ) RETURN VARCHAR2;
Description
Returns the user-defined identifier value associated with a GeoRaster object.
Usage Notes
To set a user-defined identifier value for a GeoRaster object, use the SDO_GEOR.setID procedure.
Examples
The following example returns the user-defined identifier values of the GeoRaster objects (GEORASTER column) in the GEORASTER_TABLE table, whose definition is presented after Example 1-1 in Storage Parameters.
SELECT georid, substr(sdo_geor.getID(georaster),1,50) GEOR_ID FROM georaster_table; GEORID GEOR_ID ---------- -------------------------------------------------- 2 TM_102 4 TM_104
Parent topic: SDO_GEOR Package Reference