31.9 SDO_TIN_PKG.LIST_TIN_COLUMNS
Format
SDO_TIN_PKG.LIST_TIN_COLUMNS() RETURN TIN_COLUMN_TABLE;
Description
Returns a table of type TIN_COLUMN_TABLE
which contains a list of
TIN_COLUMN_RECORD
objects.
Parameters
Usage Notes
The SDO_TIN_PKG.LIST_TIN_COLUMNS
function can be used to list the
column names of all the SDO_TIN
objects that may represent either a
TIN or a 3D mesh.
This function returns a table of type TIN_COLUMN_TABLE
which is defined as shown:
CREATE OR REPLACE TYPE TIN_COLUMN_TABLE AS TABLE OF TIN_COLUMN_RECORD;
The TIN_COLUMN_RECORD
object is defined as shown:
CREATE OR REPLACE TYPE TIN_COLUMN_RECORD AS OBJECT (
TABLE_NAME VARCHAR2(60),
COLUMN_NAME VARCHAR2(60));
In the preceding code:
TABLE_NAME
: Name of the table having a column of typeSDO_TIN
.COLUMN_NAME
: Name of the column of typeSDO_TIN
in the preceding table.
Examples
The following shows an example using the
SDO_TIN_PKG.LIST_TIN_COLUMNS
function:
SQL> SELECT * FROM TABLE (SDO_TIN_PKG.LIST_TIN_COLUMNS());
The output obtained is as shown:
TABLE_NAME COLUMN_NAME
---------- -----------
TINS TIN
Parent topic: SDO_TIN_PKG Package (TINs)