KNTA_PREPARED_COMMAND_STEPS
This table stores the actual execution steps after the steps are parsed and special commands have been expanded. The commands may contain runtime tokens that will be parsed only at runtime.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_PREPARED_COMMANDS |
PREPARED_COMMAND_ID |
PREPARED_COMMAND_ID |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
PREPARED_COMMAND_STEP_ID |
NOT NULL |
NUMBER |
System-generated identifier |
PREPARED_COMMAND_ID |
NOT NULL |
NUMBER |
Identifier for the prepared command to which this step belongs |
SEQ |
NOT NULL |
NUMBER |
Sequence in which the command steps will be executed |
COMMAND |
NULLABLE |
VARCHAR2(4000) |
Actual command that will be executed |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
PREPARED_SPECIAL_COMMAND_ID |
NULLABLE |
NUMBER |
Identifier for the prepared special command to which this step belongs |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KNTA_PREPARED_COMMAND_STEPS_N1 |
NONUNIQUE |
1 |
PREPARED_COMMAND_ID |
KNTA_PREPARED_COMMAND_STEPS_U1 |
UNIQUE |
1 |
PREPARED_COMMAND_STEP_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
KNTA_PREPARED_COMMAND_STEPS_S |
PREPARED_COMMAND_STEP_ID |