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

VIEW: SYS.KU$_CONSTRAINT2_VIEW

Object Details
Object Name: KU$_CONSTRAINT2_VIEW
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER_NUM NUMBER

NAME VARCHAR2 (128)
CON_NUM NUMBER

OBJ_NUM NUMBER

NUMCOLS NUMBER

CONTYPE NUMBER

ROBJ_NUM NUMBER

RCON_NUM NUMBER

RRULES VARCHAR2 (3)
MATCH_NUM NUMBER

REFACT NUMBER

ENABLED NUMBER

INTCOLS NUMBER

MTIME VARCHAR2 (19)
FLAGS NUMBER

SCHEMA_OBJ KU$_SCHEMAOBJ_T (2768)
SRC_COL_LIST KU$_CONSTRAINT_COL_LIST_T (64)
TGT_COL_LIST KU$_CONSTRAINT_COL_LIST_T (64)
Query Text

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


SELECT OWNER_NUM
,      NAME
,      CON_NUM
,      OBJ_NUM
,      NUMCOLS
,      CONTYPE
,      ROBJ_NUM
,      RCON_NUM
,      RRULES
,      MATCH_NUM
,      REFACT
,      ENABLED
,      INTCOLS
,      MTIME
,      FLAGS
,      SCHEMA_OBJ
,      SRC_COL_LIST
,      TGT_COL_LIST
FROM SYS.KU$_CONSTRAINT2_VIEW;

Dependencies

[top of page]

SYS.KU$_CONSTRAINT2_VIEW references the following:

SchemaSYS
TableCDEF$
TableCON$
PL/SQL PackageDBMS_METADATA - show dependent code
PL/SQL PackageDBMS_METADATA_UTIL - show dependent code
TYPEKU$_CONSTRAINT2_T
TYPEKU$_CONSTRAINT_COL_LIST_T
ViewKU$_CONSTRAINT_COL_VIEW
TYPEKU$_SCHEMAOBJ_T
ViewKU$_SCHEMAOBJ_VIEW
PL/SQL PackageSTANDARD - show dependent code
PL/SQL PackageUTL_RAW - show dependent code
SYS.KU$_CONSTRAINT2_VIEW is referenced by following:

SchemaSYS
ViewKU$_10_2_FHTABLE_VIEW
ViewKU$_ACPTABLE_VIEW
ViewKU$_FHTABLE_VIEW
ViewKU$_HNT_VIEW
ViewKU$_HTABLE_VIEW
ViewKU$_IONT_VIEW
ViewKU$_IOTABLE_VIEW
ViewKU$_PFHTABLE_VIEW
ViewKU$_PHTABLE_VIEW
ViewKU$_PIOTABLE_VIEW
ViewKU$_REF_CONSTRAINT_VIEW
ViewKU$_VIEW_VIEW