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