[Home] [Help] [Dependency Information]
Object Name: | UTL_ALL_IND_COMPS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CTYPE | CHAR | (1) | ||
INDEX_NAME | VARCHAR2 | (128) | ||
COMPONENT_NAME | VARCHAR2 | (128) | ||
TABLE_ID | NUMBER | |||
TAB_OWNER_ID | NUMBER | |||
IDX_ID | NUMBER | |||
IND_OWNER_ID | NUMBER | |||
IND_OWNER_NAME | VARCHAR2 | (128) | ||
COMP_ID | NUMBER | |||
TCOMP_ID | NUMBER | |||
CCOMP_ID | NUMBER | |||
TCCOMP_ID | NUMBER | |||
STATUS | VARCHAR2 | (1) | ||
LOCALITY | CHAR | (1) | ||
DEGREE | NUMBER | |||
ROWCNT | NUMBER | |||
JOIN_INDEX | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT CTYPE
, INDEX_NAME
, COMPONENT_NAME
, TABLE_ID
, TAB_OWNER_ID
, IDX_ID
, IND_OWNER_ID
, IND_OWNER_NAME
, COMP_ID
, TCOMP_ID
, CCOMP_ID
, TCCOMP_ID
, STATUS
, LOCALITY
, DEGREE
, ROWCNT
, JOIN_INDEX
FROM SYS.UTL_ALL_IND_COMPS;
|
|
|