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._DBA_APPLY_CONSTRAINT_COLUMNS

Object Details

Object Name:	_DBA_APPLY_CONSTRAINT_COLUMNS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEPENDENCY_NAME	VARCHAR2	(128)	Yes	Dependency name
OBJECT_OWNER	VARCHAR2	(128)	Yes	Schema of owning object
OBJECT_NAME	VARCHAR2	(128)	Yes	Owning object
COLUMN_NAME	VARCHAR2	(128)	Yes	Dependency column name
COLUMN_POSITION	NUMBER			Dependency column position

Query Text

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


SELECT DEPENDENCY_NAME
,      OBJECT_OWNER
,      OBJECT_NAME
,      COLUMN_NAME
,      COLUMN_POSITION
FROM SYS._DBA_APPLY_CONSTRAINT_COLUMNS;

Dependencies

[top of page]

SYS._DBA_APPLY_CONSTRAINT_COLUMNS references the following:

SYS: APPLY$_CONSTRAINT_COLUMNS

SYS._DBA_APPLY_CONSTRAINT_COLUMNS is referenced by following:

PUBLIC: DBA_APPLY_VALUE_DEPENDENCIES
SYS: DBMS_APPLY_ADM_INTERNAL - show dependent code