31.6 SDO_TIN_PKG.GET_NUM_POINTS

Format

SDO_TIN_PKG.GET_NUM_POINTS(
     tin IN MDSYS.SDO_TIN 
   ) RETURN NUMBER DETERMINISTIC;

Description

Gets the total number of points specified in the TIN block table for a SDO_TIN object.

Parameters

tin

SDO_TIN object to be used for analysis.

Usage Notes

The SDO_TIN object may represent either a TIN or a 3D mesh.

Examples

The following example retrieves the total number of points for the input tin object as shown:

SQL> SELECT SDO_TIN_PKG.GET_NUM_POINTS(tin) FROM tins WHERE tin_id=1;

The output obtained is as shown:

SDO_TIN_PKG.GET_NUM_POINTS(TIN)
-------------------------------
                        1065690