[Home] [Help] [Dependency Information]
Object Name: | SUMQB$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SUMQB$_1 | NORMAL | NONUNIQUE | SYSTEM | NODEID |
I_SUMQB$_2 | NORMAL | NONUNIQUE | SYSTEM | HASHVAL |
I_SUMQB$_3 | NORMAL | NONUNIQUE | SYSTEM | HASHVAL2 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMOBJ# | NUMBER | Yes | ||
NODEID | NUMBER | Yes | ||
PFLAGS | NUMBER | |||
XPFLAGS | NUMBER | |||
SFLAGS | NUMBER | |||
STATE | NUMBER | |||
TEXT | LONG | (0) | ||
TEXTLEN | NUMBER | |||
MARKER | VARCHAR2 | (4000) | ||
MARKERLEN | NUMBER | |||
HASHVAL | NUMBER | |||
HASHVAL2 | NUMBER | |||
RORDER | NUMBER | |||
SORDER | NUMBER | |||
LEAFCNT | NUMBER | |||
ORIGNODE | NUMBER | |||
PARENT | NUMBER | |||
OPTTYP | NUMBER | |||
SELCNT | NUMBER | |||
FROMPO | NUMBER | |||
FLAGS | NUMBER | |||
NUMDETAILTAB | NUMBER | |||
NUMAGGREGATES | NUMBER | |||
NUMKEYCOLUMNS | NUMBER | |||
NUMJOINS | NUMBER | |||
NUMINLINES | NUMBER | |||
NUMWHRNODES | NUMBER | |||
NUMHAVNODES | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SUMOBJ#
, NODEID
, PFLAGS
, XPFLAGS
, SFLAGS
, STATE
, TEXT
, TEXTLEN
, MARKER
, MARKERLEN
, HASHVAL
, HASHVAL2
, RORDER
, SORDER
, LEAFCNT
, ORIGNODE
, PARENT
, OPTTYP
, SELCNT
, FROMPO
, FLAGS
, NUMDETAILTAB
, NUMAGGREGATES
, NUMKEYCOLUMNS
, NUMJOINS
, NUMINLINES
, NUMWHRNODES
, NUMHAVNODES
FROM SYS.SUMQB$;
SYS.SUMQB$ does not reference any database object
SYS.SUMQB$ is not referenced by any database object
|
|
|