7.19 SDO_NFE.GET_MODEL_TABLE_NAME

Format

SDO_NFE.GET_MODEL_TABLE_NAME(
     model_id    IN SDO_NUMBER,
     table_type  IN VARCHAR2
     ) RETURN VARCHAR2;

Description

Returns the name of the table of a specified type for an NFE model.

Parameters

model_id

NFE model identifier.

table_type

Type of table whose name is to be returned. For example, the value for the feature classes table is SDO_NFE.FT_CLASS.

Usage Notes

The table name must exist in the TABLE_REG_TAB table, and the name of its sequence must exist in the SEQUENCE_REG_TAB table. When a new model is created using SDO_NFE.CREATE_MODEL_STRUCTURE, the names of all of the model’s tables and sequences are automatically registered in the appropriate views and tables.

Examples

The following example gets the name of the table that holds the feature classes in the NFE model with the ID 1.

SELECT SDO_NFE.GET_MODEL_TABLE_NAME(1, SDO_NFE.FT_CLASS);