DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_SQL_PATCHES

Object Details
Object Name: DBA_SQL_PATCHES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

set of sql patches

[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (128) Yes name of sql patch
CATEGORY VARCHAR2 (128) Yes category of sql patch
SIGNATURE NUMBER
Yes unique identifier generated from normalized SQL text
SQL_TEXT CLOB (4000) Yes un-normalized SQL text
CREATED TIMESTAMP(6) (11) Yes date stamp when sql patch created
LAST_MODIFIED TIMESTAMP(6) (11)
date stamp when sql patch was last modified
DESCRIPTION VARCHAR2 (500)
text description provided for sql patch
STATUS VARCHAR2 (8)
enabled/disabled status of sql patch
FORCE_MATCHING VARCHAR2 (3)
signature is force matching or exact matching
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      CATEGORY
,      SIGNATURE
,      SQL_TEXT
,      CREATED
,      LAST_MODIFIED
,      DESCRIPTION
,      STATUS
,      FORCE_MATCHING
,      TASK_ID
,      TASK_EXEC_NAME
,      TASK_OBJ_ID
,      TASK_FND_ID
,      TASK_REC_ID
FROM SYS.DBA_SQL_PATCHES;

Dependencies

[top of page]

SYS.DBA_SQL_PATCHES references the following:

SchemaSYS
TableSQL$
TableSQL$TEXT
TableSQLOBJ$
TableSQLOBJ$AUXDATA
SYS.DBA_SQL_PATCHES is referenced by following:

SchemaPUBLIC
SynonymDBA_SQL_PATCHES