[Home] [Help] [Dependency Information]
Object Name: | CHNF$_CLAUSES |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | |
---|---|
PCT Free: | 0 |
PCT Used: | 0 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000469110C00003$$ | LOB | UNIQUE | SYSAUX | |
SYS_IL0000469110C00005$$ | LOB | UNIQUE | SYSAUX | |
SYS_IL0000469110C00007$$ | LOB | UNIQUE | SYSAUX | |
SYS_IOT_TOP_469110 | IOT - TOP | UNIQUE | SYSAUX | CLAUSEID |
I1_CHNF$_CLAUSES | NORMAL | NONUNIQUE | SYSTEM | HASHVAL |
I2_CHNF$_CLAUSES | NORMAL | NONUNIQUE | SYSTEM | OBJECTNUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLAUSEID | NUMBER | Yes | ||
OBJECTNUM | NUMBER | |||
CHILDLIST | CLOB | (4000) | ||
CLAUSEOP | NUMBER | |||
LHS | CLOB | (4000) | ||
PREDICATEOP | NUMBER | |||
RHSVAL | CLOB | (4000) | ||
RHSTYPE | NUMBER | |||
CLAUSEFLAGS | NUMBER | |||
GLOBAL_REFCOUNT | NUMBER | |||
HASHVAL | RAW | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT CLAUSEID
, OBJECTNUM
, CHILDLIST
, CLAUSEOP
, LHS
, PREDICATEOP
, RHSVAL
, RHSTYPE
, CLAUSEFLAGS
, GLOBAL_REFCOUNT
, HASHVAL
FROM SYS.CHNF$_CLAUSES;
SYS.CHNF$_CLAUSES does not reference any database object
SYS.CHNF$_CLAUSES is not referenced by any database object
|
|
|