data-dictionary

FPSBASE.ADM_TABLE_LOOP_COLUMNS

Data Dictionary

>

FPSBASE Tables

> FPSBASE.ADM_TABLE_LOOP_COLUMNS

Table FPSBASE.ADM_TABLE_LOOP_COLUMNS"

This table stored the values used in the loop of ADM_TABLE_LOOP since dynamic queries are not allowed within a loop.

  • Schema: FPSBASE

  • Tablespace: FPSDATA

  • Primary key: OWNER, TABLE_NAME, PK_COLUMN1_VALUE, PK_COLUMN2_VALUE


Column

Type

Nullable

Comment

OWNER

VARCHAR2(30)

N

TABLE_NAME

VARCHAR2(30)

N

PK_COLUMN1_VALUE

VARCHAR2(1000)

N

The value of the first column of the primary key.