eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYS.DBMS_SQLPATCH_STATE

Object Details

Object Name:	DBMS_SQLPATCH_STATE
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace
SYS_IL0000836789C00013$$	LOB	UNIQUE	SYSTEM
SYS_IL0000836789C00014$$	LOB	UNIQUE	SYSTEM
SYS_IL0000836789C00025$$	LOB	UNIQUE	SYSTEM
SYS_IL0000836789C00027$$	LOB	UNIQUE	SYSTEM
SYS_IL0000836789C00028$$	LOB	UNIQUE	SYSTEM
SYS_IL0000836789C00032$$	LOB	UNIQUE	SYSTEM
SYS_IL0000836789C00035$$	LOB	UNIQUE	SYSTEM

Columns

Name	Datatype	Length
ACTIVE	CHAR	(1)
S_CURRENT_PATCH_ID	NUMBER
S_CURRENT_PATCH_UID	NUMBER
S_CURRENT_PATCH_VERSION	VARCHAR2	(20)
S_CURRENT_PATCH_FLAGS	VARCHAR2	(10)
S_CURRENT_PATCH_ACTION	VARCHAR2	(15)
S_CURRENT_PATCH_STATUS	VARCHAR2	(15)
S_CURRENT_PATCH_DESCRIPTION	VARCHAR2	(100)
S_CURRENT_PATCH_BUNDLE_SERIES	VARCHAR2	(30)
S_CURRENT_PATCH_BUNDLE_ID	NUMBER
S_CURRENT_REGISTRY_ROWID	ROWID	(10)
S_BUNDLEDATA	XMLTYPE	(2000)
S_BUNDLEDATA_CLOB	CLOB	(4000)
S_NOTHING_SQL	VARCHAR2	(30)
S_INSTALLED_BUNDLE	NUMBER
S_INSTALLING_BUNDLE	NUMBER
S_DATABASE_VERSION	VARCHAR2	(20)
S_DEBUG	CHAR	(1)
S_FORCE	CHAR	(1)
S_ORACLE_HOME	VARCHAR2	(500)
S_BUNDLE_DATA_TYPE	VARCHAR2	(10)
S_INIT_COMPLETE	CHAR	(1)
S_CACHED_LSINVENTORY	XMLTYPE	(2000)
S_CURRENT_PATCH_DESCRIPTOR	XMLTYPE	(2000)
S_DESCRIPTOR_CLOB	CLOB	(4000)
S_SUPERSEDING_BUNDLE	CHAR	(1)
S_SESSION_INSTALL_ID	NUMBER
S_EXISTING_BUNDLEDATA	XMLTYPE	(2000)
S_EXISTING_BUNDLE_SERIES	VARCHAR2	(30)
S_EXISTING_BUNDLE_ID	NUMBER
S_PATCH_DIRECTORY_ZIP	BLOB	(4000)
S_CONTAINER_NAME	VARCHAR2	(128)

Query Text

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


SELECT ACTIVE
,      S_CURRENT_PATCH_ID
,      S_CURRENT_PATCH_UID
,      S_CURRENT_PATCH_VERSION
,      S_CURRENT_PATCH_FLAGS
,      S_CURRENT_PATCH_ACTION
,      S_CURRENT_PATCH_STATUS
,      S_CURRENT_PATCH_DESCRIPTION
,      S_CURRENT_PATCH_BUNDLE_SERIES
,      S_CURRENT_PATCH_BUNDLE_ID
,      S_CURRENT_REGISTRY_ROWID
,      S_BUNDLEDATA
,      S_BUNDLEDATA_CLOB
,      S_NOTHING_SQL
,      S_INSTALLED_BUNDLE
,      S_INSTALLING_BUNDLE
,      S_DATABASE_VERSION
,      S_DEBUG
,      S_FORCE
,      S_ORACLE_HOME
,      S_BUNDLE_DATA_TYPE
,      S_INIT_COMPLETE
,      S_CACHED_LSINVENTORY
,      S_CURRENT_PATCH_DESCRIPTOR
,      S_DESCRIPTOR_CLOB
,      S_SUPERSEDING_BUNDLE
,      S_SESSION_INSTALL_ID
,      S_EXISTING_BUNDLEDATA
,      S_EXISTING_BUNDLE_SERIES
,      S_EXISTING_BUNDLE_ID
,      S_PATCH_DIRECTORY_ZIP
,      S_CONTAINER_NAME
FROM SYS.DBMS_SQLPATCH_STATE;

Dependencies

[top of page]

SYS.DBMS_SQLPATCH_STATE references the following:

SYS: STANDARD - show dependent code; XMLTYPE

SYS.DBMS_SQLPATCH_STATE is referenced by following:

SYS: DBMS_SQLPATCH - show dependent code