DBA_SQL_PATCHES

DBA_SQL_PATCHES displays the set of SQL patches.

Column	Datatype	NULL	Description
`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