[Home] [Help] [Dependency Information]
Object Name: | ALL_REPCOLUMN |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Replicated top-level columns (table) sorted alphabetically in ascending order
Name | Datatype | Length | Mandatory | 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 |
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;
|
|
|