[Home] [Help] [Dependency Information]
Object Name: | CHNF$_QUERY_OBJECT |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000469124C00004$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000469124C00005$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000469124C00007$$ | LOB | UNIQUE | SYSTEM | |
I1_CHNF$_QUERY_OBJECT | NORMAL | NONUNIQUE | SYSTEM | QUERYID |
I2_CHNF$_QUERY_OBJECT | NORMAL | NONUNIQUE | SYSTEM | OBJN |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERYID | NUMBER | |||
OBJN | NUMBER | |||
FLAGS | NUMBER | |||
VIRTUALCLAUSE | CLOB | (4000) | ||
SOURCE_QUERY_SEL | CLOB | (4000) | ||
SOURCE_QUERY_FROPOS | RAW | (64) | ||
SOURCE_QUERY_WHR | CLOB | (4000) | ||
REFCOLS | RAW | (32) | ||
POSITION | NUMBER | |||
TOPCLAUSEID | NUMBER | |||
JOINCLAUSEID | NUMBER | |||
MAXDEPTH | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT QUERYID
, OBJN
, FLAGS
, VIRTUALCLAUSE
, SOURCE_QUERY_SEL
, SOURCE_QUERY_FROPOS
, SOURCE_QUERY_WHR
, REFCOLS
, POSITION
, TOPCLAUSEID
, JOINCLAUSEID
, MAXDEPTH
FROM SYS.CHNF$_QUERY_OBJECT;
SYS.CHNF$_QUERY_OBJECT does not reference any database object
SYS.CHNF$_QUERY_OBJECT is not referenced by any database object
|
|
|