7.96 SDO_GEOR.getVAT
Format
SDO_GEOR.getVAT( georaster IN SDO_GEORASTER, layerNumber IN NUMBER ) RETURN VARCHAR2;
Description
Returns the name of the value attribute table (VAT) associated with a layer of a GeoRaster object.
Parameters
Usage Notes
For more information about value attribute tables, see Geographic Information Systems.
To set the name of the value attribute table to be associated with a layer of a GeoRaster object, use the SDO_GEOR.setVAT procedure.
Examples
The following example returns the value attribute tables for layers 0, 1, 2, and 3 of the GeoRaster objects (GEORASTER column) in the row with the GEORID column value of 4 in the GEORASTER_TABLE table. (It refers to a table named GEORASTER_TABLE, whose definition is presented after Example 1-1 in Storage Parameters. The output is reformatted for readability.)
SELECT substr(sdo_geor.getVAT(georaster, 0),1,20) vatTable0, substr(sdo_geor.getVAT(georaster, 1),1,20) vatTable1, substr(sdo_geor.getVAT(georaster, 2),1,20) vatTable2, substr(sdo_geor.getVAT(georaster, 3),1,20) vatTable3 FROM georaster_table WHERE georid=4; VATTABLE0 VATTABLE1 VATTABLE2 VATTABLE3 -------------------- -------------------- -------------------- ---------------- VAT0 VAT1 VAT2 VAT1
Parent topic: SDO_GEOR Package Reference