eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.KU$_PKREF_CONSTRAINT_VIEW

Object Details

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

[View Source]

Columns

Name	Datatype	Length
OBJ_NUM	NUMBER
COL_NUM	NUMBER
INTCOL_NUM	NUMBER
REFTYP	NUMBER
PROPERTY	NUMBER
NAME	VARCHAR2	(128)
ATTRNAME	VARCHAR2	(4000)
SCHEMA_OBJ	KU$_SCHEMAOBJ_T	(2768)
FOREIGNKEY	NUMBER
PK_COL_LIST	KU$_SIMPLE_COL_LIST_T	(64)

Query Text

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


SELECT OBJ_NUM
,      COL_NUM
,      INTCOL_NUM
,      REFTYP
,      PROPERTY
,      NAME
,      ATTRNAME
,      SCHEMA_OBJ
,      FOREIGNKEY
,      PK_COL_LIST
FROM SYS.KU$_PKREF_CONSTRAINT_VIEW;

Dependencies

[top of page]

SYS.KU$_PKREF_CONSTRAINT_VIEW references the following:

SYS: ATTRCOL$; CCOL$; CDEF$; COL$; COLTYPE$; DBMS_METADATA - show dependent code; DBMS_METADATA_UTIL - show dependent code; KU$_PKREF_CONSTRAINT_T; KU$_SCHEMAOBJ_T; KU$_SCHEMAOBJ_VIEW; KU$_SIMPLE_COL_LIST_T; KU$_SIMPLE_COL_VIEW; OBJ$; REFCON$; STANDARD - show dependent code; UTL_RAW - show dependent code

SYS.KU$_PKREF_CONSTRAINT_VIEW is referenced by following:

SYS: KU$_10_2_FHTABLE_VIEW; KU$_ACPTABLE_VIEW; KU$_FHTABLE_VIEW; KU$_HNT_VIEW; KU$_IONT_VIEW; KU$_IOTABLE_VIEW; KU$_PFHTABLE_VIEW; KU$_PIOTABLE_VIEW