Share this page
KNTA_PORTLET_SQL_PARAMETERS
This table stores the tokens that are part of the portlet SQL and its resolved values (if any). Not all tokens may be pre-resolved, some tokens, for example, SYS.USER_ID, may be resolved run time. Data in this table corresponds to USE_BIND_VARIABLES_FLAG in the KNTA_PORTLET_TYPES table.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KNTA_PORTLETS |
PORTLET_ID |
PORTLET_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
PORTLET_SQL_PARAMETERS_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
|
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
|
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
|
PORTLET_ID |
NOT NULL |
NUMBER |
Portlet for which the sql parameters are defined |
|
PARAMETER |
NOT NULL |
VARCHAR2(80) |
Token that is part of the SQL |
|
PARAMETER_RESOLVED_VALUE |
NULLABLE |
VARCHAR2(4000) |
Resolved value of the token. Not all tokens may be resolved. |
|
SEQ |
NOT NULL |
NUMBER |
Sequence in which the token was found in the sql. |
|
RESOLVED_FLAG |
NOT NULL |
VARCHAR2(1) |
Defines if the token was pre-resolved |
|
SQL_CLAUSE |
NOT NULL |
VARCHAR2(10) |
Defines the clause in which token appeared |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KNTA_PORTLET_SQL_PARAMETERS_N1 |
NONUNIQUE |
1 |
PORTLET_ID |
|
KNTA_PORTLET_SQL_PARAMETERS_U1 |
UNIQUE |
1 |
PORTLET_SQL_PARAMETERS_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
KNTA_PORTLET_SQL_PARAMETERS_S |
PORTLET_SQL_PARAMETERS_ID |
