7.95 SDO_GEOR.getULTCoordinate
Format
SDO_GEOR.getULTCoordinate( georaster IN SDO_GEORASTER ) RETURN SDO_NUMBER_ARRAY ;
Description
Returns the cell coordinates of the upper-left corner of a GeoRaster object.
Usage Notes
This function returns two or three numbers. If it returns two numbers, they are row and column ordinates. If it returns three numbers, they are row, column, and band ordinates.
Examples
The following example returns the row, column, and band ordinates for the upper-left corner of a GeoRaster object. (It refers to a table named GEORASTER_TABLE, whose definition is presented after Example 1-1 in Storage Parameters.)
SELECT sdo_geor.getULTCoordinate(georaster) FROM georaster_table WHERE georid=23; SDO_GEOR.GETULTCOORDINATE(GEORASTER) -------------------------------------------------------------------------------- SDO_NUMBER_ARRAY(256, 0, 0)
Parent topic: SDO_GEOR Package Reference