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

Object Details

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

Replicated columns in flavors

[View Source]

Columns

Name	Datatype	Length	Comments
FNAME	VARCHAR2	(30)	Flavor name
GNAME	VARCHAR2	(30)	Object group name
SNAME	VARCHAR2	(128)	Schema containing the object
ONAME	VARCHAR2	(128)	Object name
CNAME	VARCHAR2	(4000)	Column name
TYPE	VARCHAR2	(128)	Column type
POS	NUMBER		Ordering of column used as IN parameter in the replication procedures
GROUP_OWNER	VARCHAR2	(128)	Object group owner
TYPE_TOID	RAW	(16)	Type OID of a column of TYPE
TYPE_OWNER	VARCHAR2	(128)	Type owner of a column of TYPE
TYPE_HASHCODE	VARCHAR2	(34)	Type hashcode of a column of TYPE
TYPE_MOD	VARCHAR2	(3)	Datatype modifier of a column
TOP	VARCHAR2	(128)	Top column of this attribute column

Query Text

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


SELECT FNAME
,      GNAME
,      SNAME
,      ONAME
,      CNAME
,      TYPE
,      POS
,      GROUP_OWNER
,      TYPE_TOID
,      TYPE_OWNER
,      TYPE_HASHCODE
,      TYPE_MOD
,      TOP
FROM SYS.ALL_REPFLAVOR_COLUMNS;

Dependencies

[top of page]

SYS.ALL_REPFLAVOR_COLUMNS references the following:

SYS: ALL_TAB_COLUMNS; DBA_REPFLAVOR_COLUMNS; UTL_RAW - show dependent code; XML_SCHEMA_NAME_PRESENT - show dependent code; _ALL_REPL_NESTED_TABLE_NAMES

SYS.ALL_REPFLAVOR_COLUMNS is referenced by following:

PUBLIC: ALL_REPFLAVOR_COLUMNS