SDO_TIN_PKG.LIST

Format

SDO_TIN_PKG.LIST_TINS(
     table_name  IN VARCHAR2,
     column_name IN VARCHAR2 
   ) RETURN TIN_TABLE;

Description

Returns a list of TINs in a table of type TIN_TABLE.

Parameters

table_name: Name of the table having a column of type SDO_TIN.
column_name: Name of the column of type SDO_TIN in the preceding table.

Usage Notes

The SDO_TIN_PKG.LIST_TINS function can be used to list all the SDO_TIN objects.

This function returns a table of type TIN_TABLE which is defined as shown:

CREATE OR REPLACE TYPE TIN_TABLE AS TABLE OF TIN_RECORD;

The TIN_RECORD object is defined as shown:

CREATE OR REPLACE TYPE TIN_RECORD AS OBJECT (
  TIN SDO_TIN);

In the preceding code, the TIN parameter represents an object of type SDO_TIN.

Examples

The following shows an example using the SDO_TIN_PKG.LIST_TINS function using TINS and TIN as the table_name and column_name parameter respectively:

SELECT * FROM TABLE(SDO_TIN_PKG.LIST_TINS('TINS', 'TIN'));

The output table lists the SDO_TIN object as shown:

TIN(BASE_TABLE, BASE_TABLE_COL, TIN_ID, BLK_TABLE, PTN_PARAMS, TIN_EXTENT(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES), 
TIN_TOL, TIN_TOT_DIMENSIONS, TIN_DOMAIN(EXTENT(LOWER_LEFT, UPPER_RIGHT), SCALE, ORD_CMP_TYPE), TIN_BREAK_LINES(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), 
SDO_ELEM_INFO, SDO_ORDINATES), TIN_STOP_LINES(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES), TIN_VOID_RGNS(SDO_GTYPE, SDO_SRID, 
SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
---------------------------------------------------------------------------------------------------------------------------------------------------------
SDO_TIN('TINS', 'TIN', 9, 'TIN_BLOCKS', 'blk_capacity=100000', SDO_GEOMETRY(2003, 27700, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), 
SDO_ORDINATE_ARRAY(0, 0, 999, 999)), .05, 3, NULL, NULL, NULL, NULL, NULL, NULL)

31.10 SDO_TIN_PKG.LIST_TINS