31.7 SDO_TIN_PKG.GET_TIN_BLOCK_SORT_ORDER

Format

SDO_TIN_PKG.GET_TIN_BLOCK_SORT_ORDER(
     tin IN MDSYS.SDO_TIN 
   ) RETURN VARCHAR2;

Description

Gets the blocking type as determined by the algorithm for the SDO_TIN object.

Parameters

tin

SDO_TIN object to be used for analysis.

Usage Notes

The output of the SDO_TIN_PKG.GET_TIN_BLOCK_SORT_ORDER function can be one of the following values:

• TIN by Delaunay triangulation - This is for a TIN object.
• Mesh by consecutive submesh - This is for a 3D mesh.

Examples

The following example retrieves the blocking type as determined by the algorithm for the input tin object as shown:

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

The output obtained is as shown:

SDO_TIN_PKG.GET_TIN_BLOCK_SORT_ORDER(TIN)
------------------------------------------
TIN by Delaunay triangulation