7.78 SDO_GEOR.getPyramidMaxLevel
Format
SDO_GEOR.getPyramidMaxLevel( georaster IN SDO_GEORASTER ) RETURN NUMBER;
Description
Returns the level number of the top pyramid of a GeoRaster object.
Usage Notes
For information about pyramids, see Pyramids.
Examples
The following example returns the pyramid type and level number of the top pyramid for the GeoRaster object (GEORASTER column) in the row with an GEORID column value of 21 in the GEORASTER_TABLE table, whose definition is presented after Example 1-1 in Storage Parameters.
SELECT substr(sdo_geor.getPyramidType(georaster),1,10) pyramidType, sdo_geor.getPyramidMaxLevel(georaster) maxLevel FROM georaster_table WHERE georid=21; PYRAMIDTYP MAXLEVEL ---------- ---------- DECREASE 3
Parent topic: SDO_GEOR Package Reference