[Home] [Help] [Dependency Information]
Object Name: | _utl$_lc_ind_subs |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CTYPE | CHAR | (1) | ||
INDEX_NAME | VARCHAR2 | (128) | Yes | |
COMPONENT_NAME | VARCHAR2 | (128) | ||
TABLE_ID | NUMBER | Yes | ||
TAB_OWNER_ID | NUMBER | Yes | ||
IDX_ID | NUMBER | Yes | ||
IND_OWNER_ID | NUMBER | Yes | ||
IND_OWNER_NAME | VARCHAR2 | (128) | Yes | |
COMP_ID | NUMBER | Yes | ||
TCOMP_ID | NUMBER | Yes | ||
CCOMP_ID | NUMBER | Yes | ||
TCCOMP_ID | NUMBER | Yes | ||
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$_lc_ind_subs;
|
|
|