7.58 SDO_GEOR.getDefaultPyramidLevel
Format
SDO_GEOR.getDefaultPyramidLevel( georaster IN SDO_GEORASTER ) RETURN NUMBER;
Description
Returns the number of the default pyramid level for displaying a GeoRaster object. If this value is not set in the metadata, a null value is returned.
Usage Notes
Pyramid levels represent reduced or increased resolution images that require less or more storage space, respectively. For information about pyramids and pyramid levels, see Pyramids.
You can set the default pyramid level by using the SDO_GEOR.setDefaultPyramidLevel procedure.
Examples
The following example returns the default pyramid level for displaying a specified GeoRaster object in the table named GEORASTER_TABLE, whose definition is presented after Example 1-1 in Storage Parameters.
SELECT georid, sdo_geor.getDefaultPyramidLevel(georaster) plevel, FROM georaster_table WHERE georid = 6; GEORID PLEVEL ---------- ---------- 6 3
Parent topic: SDO_GEOR Package Reference