31.10 SDO_TIN_PKG.LIST_TINS
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
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)
Parent topic: SDO_TIN_PKG Package (TINs)