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

Object Details

Object Name:	REPCAT_REPCOLUMN_BASE
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	Mandatory	Comments
SNAME	VARCHAR2	(128)	Yes	Name of the object owner
ONAME	VARCHAR2	(128)	Yes	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_VERSION#	NUMBER			Type version# of a column of TYPE
CTYPE_NUM	NUMBER			Type of a column
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
CHAR_USED	VARCHAR2	(1)
PROPERTY	RAW	(4)
LPOS	NUMBER			Ordering of the real replicated column

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_VERSION#
,      CTYPE_NUM
,      CTYPE_MOD
,      DATA_LENGTH
,      DATA_PRECISION
,      DATA_SCALE
,      NULLABLE
,      CHARACTER_SET_NAME
,      TOP
,      CHAR_LENGTH
,      CHAR_USED
,      PROPERTY
,      LPOS
FROM SYS.REPCAT_REPCOLUMN_BASE;

Dependencies

[top of page]

SYS.REPCAT_REPCOLUMN_BASE references the following:

SYS: UTL_RAW - show dependent code
SYSTEM: REPCAT$_REPCOLUMN

SYS.REPCAT_REPCOLUMN_BASE is referenced by following:

PUBLIC: REPCAT_REPCOLUMN_BASE
SYS: DBA_REPCOLUMN; DBMS_REPCAT_UTL2 - show dependent code