[Home] [Help] [Dependency Information]
Object Name: | DBA_REGISTRY_SQLPATCH |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PATCH_ID | NUMBER | Yes | ||
PATCH_UID | NUMBER | Yes | ||
VERSION | VARCHAR2 | (20) | Yes | |
FLAGS | VARCHAR2 | (10) | ||
ACTION | VARCHAR2 | (15) | Yes | |
STATUS | VARCHAR2 | (15) | ||
INSTALL_ID | NUMBER | |||
ACTION_TIME | TIMESTAMP(6) | (11) | Yes | |
DESCRIPTION | VARCHAR2 | (100) | ||
BUNDLE_SERIES | VARCHAR2 | (30) | ||
BUNDLE_ID | NUMBER | |||
BUNDLE_DATA | CLOB | (4000) | ||
PATCH_DESCRIPTOR | CLOB | (4000) | ||
PATCH_DIRECTORY | BLOB | (4000) | ||
LOGFILE | VARCHAR2 | (500) |
Cut, paste (and edit) the following text to query this object:
SELECT PATCH_ID
, PATCH_UID
, VERSION
, FLAGS
, ACTION
, STATUS
, INSTALL_ID
, ACTION_TIME
, DESCRIPTION
, BUNDLE_SERIES
, BUNDLE_ID
, BUNDLE_DATA
, PATCH_DESCRIPTOR
, PATCH_DIRECTORY
, LOGFILE
FROM SYS.DBA_REGISTRY_SQLPATCH;
|
|
|