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_REPCOLUMN

Object Details

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

Replicated top-level columns (table) sorted alphabetically in ascending order

[View Source]

Columns

Name	Datatype	Length	Comments
SNAME	VARCHAR2	(128)	Name of the object owner
ONAME	VARCHAR2	(128)	Name of the object
TYPE	VARCHAR2	(8)	Type of the object
CNAME	VARCHAR2	(4000)	Name of the replicated column
ID	NUMBER		ID of the replicated column
POS	NUMBER		Ordering of the replicated column
COMPARE_OLD_ON_DELETE	VARCHAR2	(1)	Compare the old value of the column in replicated deletes
COMPARE_OLD_ON_UPDATE	VARCHAR2	(1)	Compare the old value of the column in replicated updates
SEND_OLD_ON_DELETE	VARCHAR2	(1)	Send the old value of the column in replicated deletes
SEND_OLD_ON_UPDATE	VARCHAR2	(1)	Send the old value of the column in replicated updates
CTYPE	VARCHAR2	(128)	Type of the column
CTYPE_TOID	RAW	(16)	Type OID of a column of TYPE
CTYPE_OWNER	VARCHAR2	(128)	Type owner of a column of TYPE
CTYPE_HASHCODE	VARCHAR2	(34)	Type hashcode of a column of TYPE
CTYPE_MOD	VARCHAR2	(3)	Datatype modifier of a column
DATA_LENGTH	VARCHAR2	(40)	Length of the column in bytes
DATA_PRECISION	VARCHAR2	(40)	Length: decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE	VARCHAR2	(40)	Digits to right of decimal point in a number
NULLABLE	VARCHAR2	(1)	Does column allow NULL values?
CHARACTER_SET_NAME	VARCHAR2	(44)	Name of character set for column, if applicable
TOP	VARCHAR2	(128)	Top column name for an attribute
CHAR_LENGTH	NUMBER		The maximim length of the column in characters
CHAR_USED	VARCHAR2	(1)	C if the width was specified in characters, B if in bytes

Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      CNAME
,      ID
,      POS
,      COMPARE_OLD_ON_DELETE
,      COMPARE_OLD_ON_UPDATE
,      SEND_OLD_ON_DELETE
,      SEND_OLD_ON_UPDATE
,      CTYPE
,      CTYPE_TOID
,      CTYPE_OWNER
,      CTYPE_HASHCODE
,      CTYPE_MOD
,      DATA_LENGTH
,      DATA_PRECISION
,      DATA_SCALE
,      NULLABLE
,      CHARACTER_SET_NAME
,      TOP
,      CHAR_LENGTH
,      CHAR_USED
FROM SYS.ALL_REPCOLUMN;

Dependencies

[top of page]

SYS.ALL_REPCOLUMN references the following:

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

SYS.ALL_REPCOLUMN is referenced by following:

PUBLIC: ALL_REPCOLUMN
SYS: DBMS_REPCAT_UTL4 - show dependent code; DBMS_REPUTIL - show dependent code