NAME

VARCHAR2(128)

NOT NULL

Name of the SQL patch

CATEGORY

VARCHAR2(128)

NOT NULL

Category of the SQL patch

SIGNATURE

NUMBER

NOT NULL

Unique identifier generated from normalized SQL text

SQL_TEXT

CLOB

NOT NULL

Un-normalized SQL text

CREATED

TIMESTAMP(6)

NOT NULL

Timestamp when the SQL patch was created

LAST_MODIFIED

TIMESTAMP(6)

Timestamp when the SQL patch was last modified

DESCRIPTION

VARCHAR2(500)

Text description provided for the SQL patch

STATUS

VARCHAR2(8)

Status of the SQL patch:

• ENABLED

• DISABLED

FORCE_MATCHING

VARCHAR2(3)

Indicates whether the signature is force matching (YES) or exact matching (NO)

TASK_ID

NUMBER

Advisor task ID that generated the SQL patch

TASK_EXEC_NAME

VARCHAR2(128)

Advisor execution name for the SQL patch

TASK_OBJ_ID

NUMBER

Advisor object ID for the SQL patch

TASK_FND_ID

NUMBER

Advisor finding ID for the SQL patch

TASK_REC_ID

NUMBER

Advisor recommendation ID for the SQL patch