[Home] [Help] [Dependency Information]

TABLE: SYS.HS$_CLASS_CAPS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: HS$_CLASS_CAPS_PK

1. FDS_CLASS_CAP_ID

Unique Key: HS$_CLASS_CAPS_UK1

1. FDS_CLASS_ID
2. CAP_NUMBER

Indexes

Index	Type	Uniqueness	Tablespace	Column
HS$_CLASS_CAPS_PK	NORMAL	UNIQUE	SYSTEM	FDS_CLASS_CAP_ID
HS$_CLASS_CAPS_UK1	NORMAL	UNIQUE	SYSTEM	FDS_CLASS_ID CAP_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
HS$_CLASS_CAPS		HS$_BASE_CAPS	HS$_CLASS_CAPS CAP_NUMBER
HS$_CLASS_CAPS		HS$_FDS_CLASS	HS$_CLASS_CAPS FDS_CLASS_ID

Columns

Query Text

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

SELECT FDS_CLASS_CAP_ID
,      FDS_CLASS_ID
,      CAP_NUMBER
,      CONTEXT
,      TRANSLATION
,      ADDITIONAL_INFO
FROM SYS.HS$_CLASS_CAPS;

Dependencies

[top of page]

SYS.HS$_CLASS_CAPS does not reference any database object

SYS.HS$_CLASS_CAPS is referenced by following:

SYS

DBMS_HS_ALT - show dependent code

DBMS_HS_CHK - show dependent code

DBMS_HS_UTL - show dependent code

HS_ALL_CAPS

HS_CLASS_CAPS