DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.SUMPRED$

Object Details
Object Name: SUMPRED$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_SUMPRED$_1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnSUMOBJ#
ColumnCLAUSEID
Columns
Name Datatype Length Mandatory Comments
SUMOBJ# NUMBER
Yes
NODEID NUMBER
Yes
PNODEID NUMBER
Yes
CLAUSEID NUMBER
Yes
NODETYPE NUMBER
Yes
NUMCHILD NUMBER

RELOP NUMBER

LOPTYPE NUMBER

ROPTYPE NUMBER

LDOBJ# NUMBER

RDOBJ# NUMBER

LCOLID NUMBER

RCOLID NUMBER

LAGGTYPE NUMBER

RAGGTYPE NUMBER

LCANOTXT VARCHAR2 (4000)
RCANOTXT VARCHAR2 (4000)
LCANOTXTLEN NUMBER

RCANOTXTLEN NUMBER

LTXT VARCHAR2 (4000)
RTXT VARCHAR2 (4000)
LTXTLEN NUMBER

RTXTLEN NUMBER

VALUE LONG (0)
VALUELEN NUMBER

NUMVAL NUMBER

COLPOS NUMBER

LFLAGS NUMBER

RFLAGS NUMBER

LINLINE# NUMBER

RINLINE# NUMBER

LINSTANCE# NUMBER

RINSTANCE# NUMBER

QBCID NUMBER
Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUMOBJ#
,      NODEID
,      PNODEID
,      CLAUSEID
,      NODETYPE
,      NUMCHILD
,      RELOP
,      LOPTYPE
,      ROPTYPE
,      LDOBJ#
,      RDOBJ#
,      LCOLID
,      RCOLID
,      LAGGTYPE
,      RAGGTYPE
,      LCANOTXT
,      RCANOTXT
,      LCANOTXTLEN
,      RCANOTXTLEN
,      LTXT
,      RTXT
,      LTXTLEN
,      RTXTLEN
,      VALUE
,      VALUELEN
,      NUMVAL
,      COLPOS
,      LFLAGS
,      RFLAGS
,      LINLINE#
,      RINLINE#
,      LINSTANCE#
,      RINSTANCE#
,      QBCID
FROM SYS.SUMPRED$;

Dependencies

[top of page]

SYS.SUMPRED$ does not reference any database object

SYS.SUMPRED$ is not referenced by any database object